Most recent update

  • Thread starter Thread starter AAE
  • Start date Start date
A

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