>>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.