Date Query

[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.

 

[Steve Schapel]

Erman,

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

- Steve Schapel, Microsoft Access MVP