If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Selecting the last 10 records from a specific date
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... |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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... |
Thread Tools | |
Display Modes | |
|
|