How do I query for list of 3 field combinations from 6 fields?

[Guest]

I would like a query to list all the 3 field combinations available from 6
fields per data row (date), then union them or such like to create a query to
list all the 3 field combinations drawn to date. From this i should be able
to do the same for a 4 field combination of the same 6. Challenging query for
me. Really stuck.

 

[Rick B]

Please give us an example. What are the fields that you are looking for?
What data do you wish to find in those fields?

 

[Guest]

Does this mean: Row (1,2,3,4,5,6) would produce ( (1,2,3), (1,2,4), (1,2,5),
1,2,6), etc?