Top ten records

  • Thread starter Thread starter George
  • Start date Start date
G

George

I have a select query with more than fifty records and
want to limit the query to only the ten most recent,
which I will then average. I can sort descending by date,
but how do I then select only the top ten, or ten most
recent?
 
Hi,


SELECT TOP 10 * FROM myTable ORDER BY date_timeField DESC;


Hoping it may help,
Vanderghast, Access MVP
 
Problem solved. Thank both of you two gentlemen!
-----Original Message-----
This is the same as Michael's answer, but uses the
Click to expand...
toolbars. On the Query Design toolbar, look for the drop
down box that says "All" in it. Type in the number of
results you want (10, 20, 15% etc.), and press Enter.
 
Problelm solved. Thank both of you two gentlemen.
-----Original Message-----
Hi,


SELECT TOP 10 * FROM myTable ORDER BY date_timeField DESC;


Hoping it may help,
Vanderghast, Access MVP





.
Click to expand...
 
Back
Top