Find first event (date field) for each person (ID field)

A

alan west

I have a query that sorts Person IDs, and within each Person ID, sorts Event
Dates. I'd like to have the query find the first Event Date for each Person
ID and return those records only. Is there a way to do this? Thanks.
 
O

Ofer

Try this

Select * From TableName Where DateField = Dmin("DateField","TableName",Id="
& [TableName].[ID])

' Assuming that you have one event per day
 
Top