Let me try
I assumed your table is called "Customer" that have field called "CustTown"
Create two queries, 1st is counted query, and 2nd is select query, like this:
1st QUERY
1. Create query of your table in design view
2. Enable Total Query (click icon "Sigma"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.