Access Query - Count Records Running Sum

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Counting certain records via VBA 1
Counting number of records based on criteria 1
Access Count query 1
How can I limit Access query to 65000 records 4
Count number of records by date 2
Counting number of records based on criteria 2
Use a report to count the # records >0 in Access 2003 2

Top