Selecting the last 10 records from a specific date
A query that would look something like the following.
SELECT TOP 10 NameField, DateField
FROM SomeTable
WHERE DateField = Date()
ORDER BY DateField DESC
In query design view
== Add the table
== Add the two fields
== Under the DateField enter criteria
= Date()
== Set the datefield to sort DESCending
== In the query properties, set Top Values to 10
This will return ties for the last position.
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
semmison 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...
|