I have a table that intentionally permits duplicate values for a field called "ID". For each ID, there is a distinct date captured in a field called "DATE". In a query, I would like to select the largest date (most recent) for each ID. Any suggestions on how to do that would be very much appreciated.

Look up Max in help.

I have that part of it. The tricky part is selecting one record for each ID. Suppose I I have 5 records in a table. The first three have an ID of "1", and the second two have an ID of "2". I would like the query to select two records. The first record corrosponds to the record that has an ID value of "1" with the max date, and the second record corresponds to the record with an ID value of "2" with the max date.

I was just trying to do the same thing myself. What I did is include [ID] in the query as Group By, and [DATE] as Max - and presto, I got the most recent date for each ID.

That is genius. Thanks.

http://www.access-programmers.co.uk/ubb/biggrin.gif

No problem - it's nice to know I can be useful!