By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,516 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,516 IT Pros & Developers. It's quick & easy.

Access 2003

P: 1
I 'm trying to create a query in Access 2003 and my question is how can I create a query to pull Top 10 records based on Sales Revenue

Please Help
Oct 6 '06 #1
Share this Question
Share on Google+
1 Reply

P: 143
Use the TOP predicate in your query. You will find it in the Queries properties. Here is an example taken from the help file.

SELECT TOP 25 FirstName AS Expr1, LastName AS Expr2
FROM Students
WHERE ((([GraduationYear])=1994))
ORDER BY GradePointAverage DESC;
Oct 6 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.