Steve Erbach
erbachs at gmail.com
Wed Jul 8 10:37:31 CDT 2009
Susan, Hey, I think that'll work! I knew I had to be missing something simple. Thank you. Steve Erbach On Wed, Jul 8, 2009 at 10:22 AM, Susan Harkins <ssharkins at gmail.com> wrote: > 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? >