Thread: Access Query to only show most recent data
View Single Post
  #1  
Old October 11th, 2007, 05:13 PM posted to microsoft.public.access
AJCB
external usenet poster
  
Posts: 54
Default Access Query to only show most recent data
I have an Access table with the following fields:
Pallet ID - eg. 11234$33
Location - eg. NW
Date/Time - eg. 10/10/2007 18:00:00

What I would like to do is have a query which shows me the latest record for
each Pallet ID.

Can this be done using Expression Builder as I have not learned SQL yet?

Cheers
AJ