Thanks very much. I am beginning to see the idea now. Use a temporary table. I'll try some experimenting.

Thanks again and best wishes,


Clive Astley

Using Pivot Table approach. As I see it, if you can produce manually a pivot table report of your data, and that is what its good at. You can then programmatically design the pivot table to match that specification. Not only that, but you can dymanically change the design to suit varying row and column arrangements.

Cheers Ray