I need to display 10 records from a table. The records have a date field. I want to display the most recent 10 records from today's date and back. What's the easiest way to do this?<BR><BR>I've used the following SELECT statement to retrieve the records with a date entered:<BR><BR>Set RS = Conn.Execute("SELECT * FROM CDRL WHERE DocDate <= Date() ORDER BY DocDate DESC")<BR><BR>However, when I use this with my While... Wend statement I get all the records. Is there a way to show only the 10 most recent records by the "DocDate" field?