Access Help

[chris_182]

Completely stuck with something at work :dapprove:
I have a table of options and corresponding values as per the simple example below:

Option Value
A 1
A 2
A 3
B 1
B 2
C 1
D 1
D 2

I want an automatic way of creating a list of all the possible combinations.
Each combination includes each option. So, in this instance, the list would be:

A1, B1, C1, D1
A1, B1, C1, D2
A1, B2, C1, D1
A1, B2, C1 ,D2
A2, B1, C1, D1
A2, B1, C1, D2
A2, B2, C1, D1
A2, B2, C1 ,D2
A3, B1, C1, D1
A3, B1, C1, D2
A3, B2, C1, D1
A3, B2, C1 ,D2

I'd appreciate if anyone could come up with an answer, be it in Access or Excel

Cheers
Chris

 

[Adamio]

Tried PM'ing you but your inbox is full

 

[chris_182]

Try again