I am drawing a blank and quite truthfully have not had a lot of time to think about this
request, so any thoughts appreciated. I have a table that holds sales detail information. The customer is requesting a report that shows total sales in decending order for each category. Easy enough, but they want (3) columns, one each for a category of product, showing sales in decending order. So the report would need to look like this.... (a simplified example here) -------------------------------------------------------- Sales by Category -------------------------------------------------------- Category A Category B Cateory C -------------------------------------------------------- ABC $5000 123 $3320 A00 $1500 XYZ $4100 321 $3005 A21 $999 XAZ $2850 999 $1852 A99 $732 etc. etc.. (The 3 digit values representing part numbers here) Note that all this data is in one table. The columns involved would be PartNo., DollarsSold and Category. There are approximately 160 parts in Category A, 50 in Category B and only 22 in Category C. So there would not be values for B and C in the lower rows. Any thoughts on an elegant solution? Thanks, -Bob
