Use query to find records with most recent date and time?

G

Guest

I have date and time fields in my table. I want to run a query where I only
get the records with the most recent date and times.
 
G

Guest

Sort the query by date and time Desc to get the recent records on top, and
then use the TOP Number to select how many records you want to display

Select Top 10 * from MyTable Order by [DateField] Desc, [TimeField] Desc

Will display the 10 recent records
===================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to select individual records 4
Most recent date 2
Max Date in a query whilst showing all fields 4
Another most-recent date query 0
Find most recent record by date and time 2
show the most recent payment 5
Most recent date prior to test date. 1
Pull Most Recent Date 12

Top