DCOUNT, SUM, or COUNT????

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

Guest

I have a table of customers called CUST. Fields are:
CUSTOMERNUMBER
STATE
CITY
ZIP (trimmed to the first three digits)

I want to run a query that will give results showing how many customers
exist in a particular zipcode.

I would like results to be something like:

AK 112
AL 200
CA 122
etc...

Could anybody please help? Thank you so much!
 
Maciek,
Using the query design grid, create a Totals query. Thta's a regular Select query, but
with View/Totals selected from the main menu.
In the State column, use Count instead of GroupBy.
 
or leave the group by for zip and add a colum to count customer number.
(would be needed if more than one zip can be in a state.)
 
Back
Top