[AccessD] Crosstab with summary query

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?
>



More information about the AccessD mailing list