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

Counting expression doesn't work when sorted by count - Access 200 5
dsum 3
Top Values Not Working 4
Query Input 1
Select Top with aggregate function 1
Help with TOP 10 query please 4
Problem with Access concatenate query 4
Why is my union query asking me to enter a parameter value? 4

Top