Query: find each record w/ value different from previous record

A

alan west

I'm working with an Access query that sorts on a) Person ID, and then b)
within each Person ID, on Date of Event. I'd like to pull out the following
records: For each Person ID, I'd like the record with the earliest Date of
Event. Is there a way to do this in a query?
 
O

Ofer

Another option is to create a group by query that will list the Id and the
min of the date

Then create another query that will link the query with the table joining Id
to Id, and DateField to MinDateField, and return all the records from the
table.
 
Top