Susan Harkins
ssharkins at gmail.com
Wed Jul 8 10:22:08 CDT 2009
Have you tried this: Add a Month() function to the query and then run a Totals on the month -- off the top of my head. Susan H. > Do I need to make 12 summary queries to summarize sales for each product > for > each month before I gather all those intermediate results together into > the > 12-month crosstab?