>>>I'm selecting from the same table but I join it with itself. It should work for any number of records, it will create all combinations.
>>
>>Naomi,
>>
>>I am afraid you will not get the permutations as requested with this select statement. I see only 2 figures that is not according to the question as far as I can see.
>>
>>Regards,
>>Koen
>
>See my next reply.

Naomi,

I see

regards,

Koen