Lowest order of items in a chart 1

[irethedo]

I have a report that contains a chart of items that I would like to display the lowest number of each but I would also like to not display any items that equal zero.

The following works but it displays items that equal zero first:


SELECT TOP 10 ([item]) AS Expr1, (Count([item])) AS [My items] FROM [my qry] GROUP BY [my qry].item ORDER BY Count([item]);


How can I not display the items that equal zero?

Thanks

 

[PaulBricker]

Try this. See if it helps.


SELECT TOP 10 ([item]) AS Expr1, (Count([item])) AS [My items] FROM [my qry]
WHERE (Count(Item)) > 0
GROUP BY [my qry].item ORDER BY Count([item]);


Paul