Diplaying the first event by date for each ContactID

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top