I need to find maximum date

[tjisaacs]

I have a table that has multiple records with same patient id but different collection dates. I want to query for the latest collection date?

Pt ID Accn # Coll Date

1001 112 6/5/02
1001 113 7/1//02

 

[JeremyNYC]

Look into totals queries in the help file.
=============
Jeremy Wallace

http://www.AlphaBetCityDataworks.com

Designing and building Access databases since 1995.

 

[GKProgrammer]

Hi tjisaacs,

In your query you could specify patient ID must equal ie. 1001 (I assume you know how to do this), then sort the query by the date field (descending). The first record in the query will be the desired record.

Let me know if this helps.

Regards,
gkprogrammer