Extract dates

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

Guest

I have a table:

AutoNumb (PK)
IdNumber
Date

The ID number can appear in multiple records with different accompanying
dates. What might a query look like that would extract an ID number and it's
two most recent dates?

Thanx,

Rip
 
Create a query that includes IDNumber and Date. Sort Descending on Date.
Right click in the query window and choose properties in the dialog that
appears. Set the Top Values property to 2. The query will now return the two
most recent dates.

BTW, it is highly recommended that you change the name of the Date field.
Date is a reserved word in Access and you should not use it as a field name.
 
I would like the query to return the two most recent dates for each ID Number.

Thanx,

Rip
 
Back
Top