Hi!
You need to give more detail as to how you file is layed
out.
Be very specific!
Biff
-----Original Message-----
seems like everybody is using either a conditional format
or some other
means.
i'm looking for something that looks up TODAY as a date,
then looks over at
a customer ID, and THEN looks at FUTURE bookings for a
one or more bookings
by that SAME customer, finally tallying how many of
TODAY's customers have
FUTURE bookings. with approximately 100 appointments
a day, it's hard to
track this manually. i'll keep looking for an answer
in this thread, and
if any programmers want more specific info, i would be
happy to pay for help.
would it help if i imported the datafile into access?
then is there a
query or something? i'm pretty amateur at this, but
not computer stupid.
neil
"neil" wrote:
i have repeating customers that book appointments in
advance. this
appointment list winds up in an excel sheet. i want
to find future
appointments that have the same client ID as an
appointment today (to find
out how many of my current customers are booked for
future visits).
neil
.
|