Does anyone have a clue on how to limit a table (using a Query) to the
most recent 2 records by date ?
Example:
I have a table containing
ProjectAreaID (primaryKey)
ProjectID
Date
For each Project ID, there exists more than 4 records each having a
different date (and thus also having a unique ProjectAreaID). I would
like a Query, which will provide the same fields as above, but only
show the most recent 2 dates for each ProjectID (and the ProjectAreaID
as well).
When I try to use the Max function, and include the PrimaryKey, it
automatically expands the recordset and shows all the records...
HELPPPPPPP !!!!
Please email as well as post.
Best
Shai
ny****@yahoo.com