>If you have found it cool than you probably would like pivot:) It takes some time to see the power (simple pivot doesn't show it really) but once you do it is cooler I think. For example one of the features I like about pivot is that I can 'send' 200-300K rows to Excel sheet (and it may be old versions that had only 64K rows per sheet) under a second to get practically "cross tabbed" data. If you wonder where did a value come from you simply "expand details" and you get the rows that caused that aggregated value. Here is a sample:

While following your suggestion I googled xlconstants.h and came to one of your postings in Foxite on how to create it from Excel.

So thanks again, though Calvin is the one I really need to thank for this one.

Alex