Grand Total for a specific field within a report subgroup

[BAmyot]

Hello,
I have a report that is grouped first by the date for each day. Within each day the report is sub-grouped by "Stacker". The only two groups for "Stacker" are "East" and "West".

The sum or total for "East" and "West" display fine within each day. However, at the end of the report I would like to show the totals for "East" and "West" over the entire report which may contain several or more days.

I hope this makes sense.

Baffled in Houston

 

[dhookom]

Totals of what? You don't provide a field that you are summing? Assuming this field is named [Qty], you could add text boxes in the report footer with control sources like:
=Sum(Abs([Stacker]="East") * [Qty])
=Sum(Abs([Stacker]="West") * [Qty])


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[BAmyot]

Sorry the vague question. I am new to this.

You however, gave me a very specific answer that worked great. I substituted the "[Qty]" portion for the field I wanted and it worked!

Thanks very much, I will try to make my questions more specific in the future.

Cheers,

BAmyot