> But I think there is a way to do this with a procedure using while..next.
> Am I right in thinking this or should I just carry on with creating
> the new table?

Usually such things are called "cross-table" and are done by report
tool. Only if number of columns in result is fixed you can try to use
CASE for tossing sums into them.

SY, SD.