Combination of table records

[theredspecial]

Hi,

I have this table (with 1 column, 14 records), now I need to make a new
table showing all possible combinations of these records, to which I can than
add more columns.

BTW the table is used elsewhere.

Regards Robert

 

[Jerry Whittle]

Can't wrap my brain around this one. Please show the records for the existing
table, with the correct table and column names, and an example of the
expected results.

 

[Tom van Stiphout]

On Thu, 27 Dec 2007 06:10:02 -0800, theredspecial

"all possible combinations" sounds like you want a cartesian product.
Create a new query, select your table twice, and do not draw a
relationship between them. Drag the field from each table to the grid.

-Tom.

 

[theredspecial]

Table 1:
label: "region"
record region 1
record region 2
etc.

Desired table:
label" "from-region" "to-region"
record region 1 region 1
record region 1 region 2
record region 2 region 1
record region 2 region 2

 

[theredspecial]

hadn't seen this reply yet: it works... thanks

On Thu, 27 Dec 2007 06:10:02 -0800, theredspecial

"all possible combinations" sounds like you want a cartesian product.
Create a new query, select your table twice, and do not draw a
relationship between them. Drag the field from each table to the grid.

-Tom.