Most recent date query

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
 
M

[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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates across multiple fields 3
Addition across multiple fields 8
Most recent date 2
Help needed to create a query 0
Most 3 recent dates in separate columns 2
Query to Pull Most Recent Call with a Callback Date Scheduled 10
Date Query 4
Another most-recent date query 0

Top