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

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

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