Nov 6, 2002 #1 callhandler Programmer Joined Oct 25, 2002 Messages 11 Location US I have a simple table with dates in it (lots of them). How do I write a query to select the 10 most recent dates in the list?
I have a simple table with dates in it (lots of them). How do I write a query to select the 10 most recent dates in the list?
Nov 6, 2002 #2 DanJR Technical User Joined Oct 29, 2002 Messages 392 Location AU Hi there, SELECT top 10 myTable.myDate FROM myTable ORDER BY myTable.myDate DESC Cheers, Dan Upvote 0 Downvote
Nov 6, 2002 Thread starter #3 callhandler Programmer Joined Oct 25, 2002 Messages 11 Location US OK, I apologize. I over simplified the problem. The date field has data in the format: mm/dd/yy hh:mm (ie it has time as well) I need to select the 10 most recent days, not the 10 most recent fields. Upvote 0 Downvote
OK, I apologize. I over simplified the problem. The date field has data in the format: mm/dd/yy hh:mm (ie it has time as well) I need to select the 10 most recent days, not the 10 most recent fields.