select top

  • Thread starter Thread starter Striker
  • Start date Start date
S

Striker

What is the best way to select the top 5 records from a field configured as
DATE/TIME in Access 2007? I know I can select * and order by, to get the
last records. I only need the last 5 by the date they were added to the
table.

Thanks
 
Striker said:
What is the best way to select the top 5 records from a field configured
as DATE/TIME in Access 2007? I know I can select * and order by, to get
the last records. I only need the last 5 by the date they were added to
the table.
Click to expand...


If I understand you correctl, the query would be along these lines:

SELECT TOP 5 * FROM [MyTable]
ORDER BY [MyDateTimeField] DESC
 
OK, so it's the same as SQL. I was doing that as a select top 10. it kept
returning 16 records. I did notice some of the dates were the same on the
records however.


Dirk Goldgar said:
Striker said:
What is the best way to select the top 5 records from a field configured
as DATE/TIME in Access 2007? I know I can select * and order by, to get
the last records. I only need the last 5 by the date they were added to
the table.
Click to expand...


If I understand you correctl, the query would be along these lines:

SELECT TOP 5 * FROM [MyTable]
ORDER BY [MyDateTimeField] DESC

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Striker said:
OK, so it's the same as SQL. I was doing that as a select top 10. it
kept returning 16 records. I did notice some of the dates were the same
on the records however.
Click to expand...


The TOP predicate makes no attempt to distinguish among records that have
the same value in the ORDER BY field(s). It returns them all. If you need
to return exactly 5 (or whatever), you can include the table's primary key
as a second ORDER BY field. Of course, then you have to understand that
your "top 5" aren't really an exclusive set.
 
Back
Top