Crazy Counting

[gbharris]

I'm running a query that references on a specific equipment code. I'm trying to query to show when I get 5 of any one item code. Can anyone help?



If this isn't possible, is there a way to configure a report to count the number of records displayed in a one up sequence and return only that count of record i'm looking for?

Thanks in advance.

[pbaldy]

Difficult to answer without knowing the data structure. If you're counting transactions:

SELECT ItemCode, Count(*) AS HowMany
FROM TableName
GROUP BY ItemCode
HAVING Count(*) > 4