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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
===================================
 
Back
Top