tickler system based on dates in Access 2000,?

[Guest]

We have a table of client names and all the dates of their visits with our
doctors. I need to extract the most recent date for each client. Presume by
query? How to get that one record of most recent date?
(We will then use most recent date and DateDiff function compare to Now to
get a list of how long it has been for each client.)

 

[Larry Linson]

We have a table of client names and all the dates of
their visits with our doctors. I need to extract the most
recent date for each client. Presume by query? How
to get that one record of most recent date? (We will
then use most recent date and DateDiff function
compare to Now to get a list of how long it has been
for each client.)

Sort by date in descending order, and use the Top Values property of the
Query to show just one. You can do this in the Query Builder... move the
date to the left of any other field on which you are sorting, and choose
Descending in the Sort row for the Date. Right click the top part of the
Query Builder screen, choose Properties, and choose Top Values.

Larry Linson
Microsoft Access MVP

 

[Guest]

Sort by date in descending order, and use the Top Values property of the
Query to show just one. You can do this in the Query Builder... move the
date to the left of any other field on which you are sorting, and choose
Descending in the Sort row for the Date. Right click the top part of the
Query Builder screen, choose Properties, and choose Top Values.

I'm still missing something here - this only brings me the one record of the
one patient that had the most recent visit of all patients. I can't seem to
bring up the most recent visit for each patient name in the master table of
visits. Is there another property to set?