Need help on query

[gear]

I have a query SELECT ......... WHERE ........ ORDER BY MyTable.DateRecd
[DateRecd] is a date field in my table. This query returns records I want in my form, the oldest date record being the first in the list. How do I change the query so that I get the latest entered record to appear first and then other records in descending order? I hope I made it clear. Please help

 

[boblarson]

ORDER BY MyTable.DateRecd DESC

 

[gear]

Thank you, it worked.

 

[boblarson]

Oh, and just as an FYI - You normally don't need to put anything for ascending, just DESC for descending. But, if you want to be explicit about ascending you can put ASC for that.