>>HELP _ frustrated in gloom over non-functioning pivots..............
snipped..

Sorry Cetin, not to you but the original.

I haven't tried it but there is an example of using SQL to pivot a table at the 'Ask the SQL Pro' site, http://www.inquiry.com/techtips/thesqlpro/index.html

Steve