Query Help

I have a table that has zip codes listed multiple times for different plan
areas, so one zip code might be listed 4 times once for northeast, once for
east, etc. I would like to try to set up a query that would take an
incumbent list of zips and bump it up against that zip code list with the
multiple plans, but when it finds a match, list the plans in one field. So
if 15555 is listed 4 times in the main table, is it possible to return a file
after the incumbent match that would have 15555 then in the next field have
northeast, east, etc. rather than returning 4 seperate records?
What I am trying to do is a plan count for the incumbent zip list but i
don't want to count a zip code more than once. This might be a pipe dream on
my part, but was hoping I could find an Access Guru out there that might be
able to help!!
Thanks

DCL -

You can do this pretty easily with two queries. First to a crosstab query
with the row headers as the zip codes, and the column headers as the plan
areas. Then create a second query based on the first query that just shows
the zip code in one field, then appends all the plan area records together
for the next field.
--
Daryl S


"DCL" wrote:

I have a table that has zip codes listed multiple times for different plan
areas, so one zip code might be listed 4 times once for northeast, once for
east, etc. I would like to try to set up a query that would take an
incumbent list of zips and bump it up against that zip code list with the
multiple plans, but when it finds a match, list the plans in one field. So
if 15555 is listed 4 times in the main table, is it possible to return a file
after the incumbent match that would have 15555 then in the next field have
northeast, east, etc. rather than returning 4 seperate records?
What I am trying to do is a plan count for the incumbent zip list but i
don't want to count a zip code more than once. This might be a pipe dream on
my part, but was hoping I could find an Access Guru out there that might be
able to help!!
Thanks

i am a starter access user...is it easy to find instructions on how to do
those types of queries in the help section? thanks so much

"Daryl S" wrote:

DCL -

You can do this pretty easily with two queries. First to a crosstab query
with the row headers as the zip codes, and the column headers as the plan
areas. Then create a second query based on the first query that just shows
the zip code in one field, then appends all the plan area records together
for the next field.
--
Daryl S


"DCL" wrote:

I have a table that has zip codes listed multiple times for different plan
areas, so one zip code might be listed 4 times once for northeast, once for
east, etc. I would like to try to set up a query that would take an
incumbent list of zips and bump it up against that zip code list with the
multiple plans, but when it finds a match, list the plans in one field. So
if 15555 is listed 4 times in the main table, is it possible to return a file
after the incumbent match that would have 15555 then in the next field have
northeast, east, etc. rather than returning 4 seperate records?
What I am trying to do is a plan count for the incumbent zip list but i
don't want to count a zip code more than once. This might be a pipe dream on
my part, but was hoping I could find an Access Guru out there that might be
able to help!!
Thanks

DCL -

The query wizards will help you through these. When you select a new query,
use the Crosstab Query Wizard for the first one, and the simple Query Wizard
for the second one. There is a lot of information in help - both within
Access and on-line on these.

--
Daryl S


"DCL" wrote:

i am a starter access user...is it easy to find instructions on how to do
those types of queries in the help section? thanks so much

"Daryl S" wrote:

DCL -

You can do this pretty easily with two queries. First to a crosstab query
with the row headers as the zip codes, and the column headers as the plan
areas. Then create a second query based on the first query that just shows
the zip code in one field, then appends all the plan area records together
for the next field.
--
Daryl S