How can I get the latest record of unique recordsets in a table using query

[pjustin1]

Hi,
I have fields in a table which will store the time and date of a record when it is added into a table.
Is it possible to make a query to get the all the latest records these fields and output it to a report?

What commands or operaters should I use to make this work?

Or do I need to use VBA?

Thanks!

 

[Jack Cowley]

Check out Top Value in Help. I think you will find your answer there.