Query to select the highest 3 numbers

[Guest]

Hello,
I have a table for employees called employees grades. This table has 4
fields, emp ID, Name, grades and grade number. The grade number is
increasing, e.g , in the grade number 1, the value will be for example 20. In
grade number 2 the value will be 10. What I want to do is making a query to
select the highest 3 grades number not the values. Any help please?
Thanks

 

[Roger Carlson]

Use a Top query:

SELECT TOP 3 [emp ID], [Name], [grades], [grade number]
FROM [employee grades]
ORDER BY [grade number] DESC;

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

it works, thanks

Use a Top query:

SELECT TOP 3 [emp ID], [Name], [grades], [grade number]
FROM [employee grades]
ORDER BY [grade number] DESC;

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Hello,
I have a table for employees called employees grades. This table has 4
fields, emp ID, Name, grades and grade number. The grade number is
increasing, e.g , in the grade number 1, the value will be for example 20.
In
grade number 2 the value will be 10. What I want to do is making a query
to
select the highest 3 grades number not the values. Any help please?
Thanks