Combination of table records

  • Thread starter Thread starter theredspecial
  • Start date Start date
T

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
 
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.
 
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.
 
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
 
hadn't seen this reply yet: it works... thanks

Tom van Stiphout said:
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.
Click to expand...
 
Back
Top