Why is my Top Value query not working right?

H

hotplate74

I am trying to get the 10 ten values. When I sort Descending I get all
the values, when I dont sort I get 10 values which are not the 10 ten.

This query gives me 10 values in alphabetical order based on the Expr1:
SELECT TOP 10 qryTop10.Expr1, qryTop10.CountOfConcernNumber FROM
qryTop10 GROUP BY qryTop10.Expr1, qryTop10.CountOfConcernNumber;

This query gives me all the values in order from the highest count to
lowest:
SELECT TOP 10 qryTop10.Expr1, qryTop10.CountOfConcernNumber FROM
qryTop10 GROUP BY qryTop10.Expr1, qryTop10.CountOfConcernNumber ORDER
BY qryTop10.CountOfConcernNumber DESC;


Why is the second query not limiting the list to 10?


James
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

0uery criteria not working 1
convert access date Format() to French date , use of ORDER BY SQL 4
Select Top with aggregate function 1
Help with TOP 10 query please 4
Top Values Not Working 4
Query Question 1
Top 3 per group 3
query to get top player 8

Top