View Single Post
  #2  
Old June 3rd, 2010, 07:14 AM posted to microsoft.public.access.gettingstarted
xps35
external usenet poster
 
Posts: 22
Default Selecting the last 10 records from a specific date

=?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