Access Query - Count Records Running Sum

B

Brenda

I want to count the number of records and then reset the count by a certain
field in a query (not report). In other words if I have a list of addresses
by State, I need to count the records for each state ie. 1,2,3,4,5 etc and
then when the State changes it starts counting again.

Thanks for your help
 
M

Maurice

Brenda,

I think you can accomplish this by using a regular query. Use the Totals
button in the query and in the querygrid group by - count

Maurice
 
Top