help with a query

A

accessnovice

having finally mustered the humility to ask for help...

I have a data file with three variables...zip code, <event>, and count (the
number of times the event occurred in the zip code.

I am trying to figure out how to extract the event and count data from a
designated set of zip codes, and am at the end of my rope. ANy suggestions
would be much appreciated and get you my vote for canonization.
 
R

rKp

What do you mean by data file? Is your information stored in a table?

You can write a query like this:

select event, count(*)
from mytable
where zipcode in (zip1, zip2..)

Is this what you are looking for?

R
 
A

accessnovice

the data are in an excel spreadsheet that I imported into a table.
Would I write this query using the wizard?
thanks for your help.
 
M

Max

This is a forum for users of the software program, Microsoft Access, which is
a relational database program. You need to find a place that answers Excel
questions; I suggest starting by posting your question to www.Google.com.
 
R

rKp

yes, the wizard would be the easy way to go.

you said that you want to see the totals for a designated set of zip codes.
will they change each time you seek the information, or is it always going to
remain the same?
 
Top