Most recent date query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top