=?Utf-8?B?c2VtbWlzb24=?= wrote:
I have a date field and name field, I want to return the last 10 Name records
entered from a specific date..... ie: Count back 10 records in the date field
from Todays date and display the names from that date, to today.... seems
really simple but I can't get it right...
You can use TOP in an query. Something like:
SELECT TOP 10 FROM ...... ORDER BY SomeField DESC
But.....
You must be able to sort the entries by a field that tells the order of
entry.
--
Groeten,
Peter
http://access.xps350.com