Query to Pull Last Date

  • Thread starter Thread starter Frolickin
  • Start date Start date
F

Frolickin

I have a table which has the following fields:

AutoID, Cacher, CacheName, FindDate

AutoID is the primary key
Cacher, CacheName, and FindDate can all repeat.
This table has thousands of entries. Each time someone finds a cache, his
name is entered along with the name of the cache he found and the date he
found it. Simple enough.

I would like to create a query that pulls each CacheName and the last date
assoiciated with it.

How would I list just the last date for each CacheName?

I appreciate the help.
 
1. Create a query into this table.

2. Depress the Total button on toolbar (upper Sigma icon).
Access adds a Total row to the grid.

3. Drag CacheName into the grid.
Accept "Group By" in the Total row.

4. Drag FindDate into the grid.
In the Total row under this field choose "Max".
 
Back
Top