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 based on two unrelated tables
I am trying to build a query, based on two unrelated tables, and I am
encountering some difficulties. i think Access is building something called a 'Cartesian Product' (according to the Access 2007 Bible). There really isn't a relationship between the two tables, but I was hoping to get all data in one table, and export to an Excel sheet (for creating various reports with Pivot Tables). Anyway, the Cartesian Product is creating wayyyyy too many records, or combinations of records, and the Union Query is stacking inappropriate data in inappropriate fields (columns) and this is totally screwing up my pivot tables. Thanks for any and all help, Ryan--- -- RyGuy |
#2
|
|||
|
|||
Query based on two unrelated tables
It puzzles me how you would expect to combine totally unrelated data into one
table. And, yes, you are getting a Cartesian Product. If the table structures are the same, you can use a Union query to export the data. If they structures are not the same, can you describe what the data are like and how you want to put them together? -- Dave Hargis, Microsoft Access MVP "ryguy7272" wrote: I am trying to build a query, based on two unrelated tables, and I am encountering some difficulties. i think Access is building something called a 'Cartesian Product' (according to the Access 2007 Bible). There really isn't a relationship between the two tables, but I was hoping to get all data in one table, and export to an Excel sheet (for creating various reports with Pivot Tables). Anyway, the Cartesian Product is creating wayyyyy too many records, or combinations of records, and the Union Query is stacking inappropriate data in inappropriate fields (columns) and this is totally screwing up my pivot tables. Thanks for any and all help, Ryan--- -- RyGuy |
#3
|
|||
|
|||
Query based on two unrelated tables
Sorry to confuse you Dave. I'm still learning about this stuff, so it's
confusing for me too. The structures of these tow tables are not the same, so I don't believe the union query will give me what I need. I will just export the two tables to Excel and do it in that environment. Thanks, Ryan--- -- RyGuy "Klatuu" wrote: It puzzles me how you would expect to combine totally unrelated data into one table. And, yes, you are getting a Cartesian Product. If the table structures are the same, you can use a Union query to export the data. If they structures are not the same, can you describe what the data are like and how you want to put them together? -- Dave Hargis, Microsoft Access MVP "ryguy7272" wrote: I am trying to build a query, based on two unrelated tables, and I am encountering some difficulties. i think Access is building something called a 'Cartesian Product' (according to the Access 2007 Bible). There really isn't a relationship between the two tables, but I was hoping to get all data in one table, and export to an Excel sheet (for creating various reports with Pivot Tables). Anyway, the Cartesian Product is creating wayyyyy too many records, or combinations of records, and the Union Query is stacking inappropriate data in inappropriate fields (columns) and this is totally screwing up my pivot tables. Thanks for any and all help, Ryan--- -- RyGuy |
Thread Tools | |
Display Modes | |
|
|