"multiplying" fields

[werfnerf]

Hi, I'm fairly new to Access. I'm trying to create a query that "multiplies" two fields from unrelated tables, to get all possible combinations. Essentially creating a 2-D array and then exploding it.

For example, tab1.fieldX has the entries
1, 2, 3
tab2.fieldY has the entries
a, b, c

I want a query that will produce two columns, X and Y
with entries
1,a
1,b


1,c
2,a
2,b

etc.

Is this possible?

Thank you!!

[jzwp11]

Yes, just include both tables in the query and select the field from each table you want. Since the tables are unrelated, you will get a Cartesian product of the two tables.

[werfnerf]

Thanks! For some reason, I kept getting an error message when I tried. Whatever was wrong seems to have fixed itself.

Thanks for your help!

[jzwp11]

Glad to hear that you got it resolved.