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?
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?
Review the Similar Threads links at the bottom of this page.
Select actnumber, count(actnumber) from table