If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Query Help
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 |
#3
|
|||
|
|||
Query Help
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 |
#4
|
|||
|
|||
Query Help
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 |
Thread Tools | |
Display Modes | |
|
|