John,
Thanks for the reply. What I mean "a count of 5 Zip codes" is 5 zip codes
out of perhaps several hundred. I need to supply this information to the
local Post Office every time a mass mailing is sent by a local non-profit
organization (not asking for money
).
Ok... I'll assume you have a table named Mailings with a primary key
MailingID and a field Zip (adjust these names to match your own
table).
Create a query by adding Mailings to the query grid; select MailingID
and Zip. Click the Greek Sigma icon (looks like a sideways W) to make
it a Totals query. Change the default Group By operator on MailingID
to Count, and to Where on Zip. On the Criteria line under Zip type
IN("48823", "72712", "02338", "83660", "98023")
to find some of my former residences (or your own preferred codes...)
Add any other needed criteria similarly using the Where operator.
Open the query and you should see a single record with the count of
records.
John W. Vinson[MVP]