Most recent date query

[GLS]

Hi
I work in a hospital where patients will have a series of attendances over
many dates, recorded on the 'outpatients' table. Is there a way I can query
this to only show the most recent attendance for each patient.

Many thanks

GLS

 

[[MVP] S.Clark]

I do this with two queries. The first locates the max date per patient id.
The 2nd query is based on the first, and is linked by both fields to the
data, which allows you to display other info about the max visit.

 

[GLS]

Thanks for replying Steve. How do you identify the max date per patient ID
though?
GLS