How to count the number of times each account # exists in a query?

[Russellh]

I have a query that has penalties account number and time period in it. So there is a record for each month that each account had a penalty.
How can I total how many times each account had a month with a penalty?

[orange]

Review the Similar Threads links at the bottom of this page.

[ranman256]

Select actnumber, count(actnumber) from table