Select TOP 20

[Scott Reynolds]

Hello!

Could someone please tell me why this query does not show top 20 Products
ordered by Hits?

SELECT TOP 20 Id, ProductName, Hits
FROM Products
ORDER BY Hits DESC;

Thank you in advance!
Scott

 

[Douglas J. Steele]

What does it show? If there are more than 20 shown, that's because there
must be ties on Hits.

 

[Arvin Meyer]

I'd take the ID value out of the query. As long as it's there you can't
count the other fields.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access