Help with report sums

[Guest]

I have a report that pulls production numbers off of a query.

Right now, it sums and totals fine, as long as I filter the query by the
production dates I want. Here is what I would like tit to do.

Leave the query unfiltered so all production is there.

then...
have mulitple columns for Quarter1, Quarter2, etc.

So i would essentially duplicate the column of groupings and totals I have
now into 4 identical columns, with each of them being filtered (thus summed)
to a different date range.

How do I need to change to control source of my sum boxes to make this happen?

I currently just have =sum[qtyProduced] in the footers of each group. So I
get the production total for all records in the query, not just a specific
quarter.

Thanks,
Diane

 

[Guest]

Maybe use a crosstab query with dates as column headings set to quarters.

 

[Guest]

Perfect. Thank you so much!!

Maybe use a crosstab query with dates as column headings set to quarters.
--
KARL DEWEY
Build a little - Test a little

I have a report that pulls production numbers off of a query.

Right now, it sums and totals fine, as long as I filter the query by the
production dates I want. Here is what I would like tit to do.

Leave the query unfiltered so all production is there.

then...
have mulitple columns for Quarter1, Quarter2, etc.

So i would essentially duplicate the column of groupings and totals I have
now into 4 identical columns, with each of them being filtered (thus summed)
to a different date range.

How do I need to change to control source of my sum boxes to make this happen?

I currently just have =sum[qtyProduced] in the footers of each group. So I
get the production total for all records in the query, not just a specific
quarter.

Thanks,
Diane