Date Query

  • Thread starter Thread starter Erman Samelo
  • Start date Start date
E

Erman Samelo

I have a table that tracks every date an item is received
by my office. If one item goes back and forth numerous
times between two offices, that item will also have
numerous "date received" entry. I'm trying to construct a
query that only generates the most current date entered.
Is there a way to do this? Thanks.
 
Erman,

Something like:
SELECT Item, Max([date received]) AS LatestDate
FROM YourTable
GROUP BY Item

- Steve Schapel, Microsoft Access MVP
 
Back
Top