Most recent update

[AAE]

I have a table that has historical monthly performance for each fund ID #,
shown below:

ID Date
1 10/2008
1 11/2008
1 12/2008
2 10/2008
2 11/2008
3 10/2008


I want to show, for each ID, only the most recent date. How do I go about
this?

 

[Allen Browne]

1. Create a query using this table.

2. Depress the Total button on the toolbar (in query design.)
Access adds a Total row to the query design grid.

3. In the Total row under ID, accept Group By.

4. In the Total row under the date field, choose Max.

If you actually have other fields you need to include as well, this link may
help:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm