DCOUNT, SUM, or COUNT????

[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!

 

[Al Camp]

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.

 

[Ron2005]

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.)