Latest date

[Guest]

Hi,

I have a table in access that lists all incidents by stores over a 2 year
period.

Question: What expression can I use in a query that would return the last
incident for each store over that period of time?

Thanks


..

 

[pietlinden]

Hi,

I have a table in access that lists all incidents by stores over a 2 year
period.

Question: What expression can I use in a query that would return the last
incident for each store over that period of time?

Thanks

use a totals query, group by Store, get MAX of date.

 

[Guest]

Thats great, thanks a million.
--
..

use a totals query, group by Store, get MAX of date.

 

[Guest]

How would I go about grabbing the last 2 incidents for each store.

Glenn_H

 

[Guest]

The answer was found in another post.

http://allenbrowne.com/subquery-01.html#TopN