Top ten records

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

 

[Michel Walsh]

Hi,


SELECT TOP 10 * FROM myTable ORDER BY date_timeField DESC;


Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Problem solved. Thank both of you two gentlemen!

-----Original Message-----
This is the same as Michael's answer, but uses the

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.

 

[Guest]

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





.