Latest date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


..
 
LucB said:
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
Click to expand...

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