Permutations

[Margie]

I have a table with year 1, 2, and 3 across in columns and have 13 rows of
data that start at 1 and go to 4 in one-fourth increments. For example, row
1 is 1,1,1; row 2 is 1.25, 1.25, 1.25, row 3 is 1.50, 1.50, 1.50 all the way
down to 4. I know that I have 1706 possible combinations (in
EXCEL,=permut(13,3). I need to know if there is a way to have ACCESS
actually compute those
combinations and show them on my datasheet to import to EXCEL. I need this
for a project at
work. Appreciate any help.

 

[vbasean]

I have a table with year 1, 2, and 3 across in columns and have 13 rows of
data that start at 1 and go to 4 in one-fourth increments.  For example,row
1 is 1,1,1; row 2 is 1.25, 1.25, 1.25, row 3 is 1.50, 1.50, 1.50 all the way
down to 4.  I know that I have 1706 possible combinations (in
EXCEL,=permut(13,3).  I need to know if there is a way to have ACCESS
actually compute those
combinations and show them on my datasheet to import to EXCEL.  I need this
for a project at
work.  Appreciate any help.  

have you read this article?
http://www.ozgrid.com/forum/showthread.php?t=80746

 

[John W. Vinson]

I have a table with year 1, 2, and 3 across in columns and have 13 rows of
data that start at 1 and go to 4 in one-fourth increments. For example, row
1 is 1,1,1; row 2 is 1.25, 1.25, 1.25, row 3 is 1.50, 1.50, 1.50 all the way
down to 4. I know that I have 1706 possible combinations (in
EXCEL,=permut(13,3). I need to know if there is a way to have ACCESS
actually compute those
combinations and show them on my datasheet to import to EXCEL. I need this
for a project at
work. Appreciate any help.

A Cartesian Join query will do this for you: add the table to the query grid
three times, without ANY join line. It's not clear to me what the three
(redundant and non-normalized???) "year" fields have to do with anything
though! The cartesian join will work on a table with just one field with the
13 possible values.