Diplaying the first event by date for each ContactID

[Guest]

I have Contacts who have had several jobs. I wish to run a query that lists
only the first job (first date of EmploymentStart in the Employment table)
for each ContactID in the Contacts Table. I can find the first date, but not
the first date for each client.

 

[Allen Browne]

1. In query design view, click the Totals button on the toolbar.
Access adds a Total row to the design grid.

2. In the Total row under the ContactID field, accept Group By.

3. In the Total row under the date, choose Min.

 

[Guest]

Thanks ... so simple, I missed the obvious

Cheers,

John