1 Page Summary Report to find how many customers by state.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that has around 38,000 customers. I would like to create a
1 page summary report that shows how many customers there are per state
without showing all the customer information. I just want the report to show
the number of customers per state. I have a state field with all the states
in it. Can someone help me figure out how to do this. Thank you!
 
You need a totals query to base your report on.

Open a new query.
Add your table
Add the state field TWO times
Click on View: Totals in the menu bar
Change one of the GROUP BY in total line to COUNT

Use this query to build your report.
 
Thank you so much!

John Spencer said:
You need a totals query to base your report on.

Open a new query.
Add your table
Add the state field TWO times
Click on View: Totals in the menu bar
Change one of the GROUP BY in total line to COUNT

Use this query to build your report.
Click to expand...
 
Back
Top