Can I get grand total for items within a report group

[Divindunk]

Hi



I have a production report which is grouped by Machine and then by Shift (A, B & C) I have totals for each shift for each machine. Can I get a grand total of the individual shifts at foot of report i.e. grand total for A, B & C shift for all machines? Any assistance would be much appreciated, thanks.

[ranman256]

in the report, create a Shift group band, make the footer visible.
ad the Amt field, (or whatever your field name is)
and set it to SUM(amt)

do the same for the report footer: SUM(amt)
this will sum all shifts.

[Divindunk]

Hi thanks for the response. I am not I understand your solution but you say at the this will sum all the shifts and having read my original question again, I don't think I made it clear that I have totals for each shift A B & C in the shift group footer but want to sum each shift separately to give a grand total for the A shift, B shift and the C shift as separate items at the end of the report? Will the solution you have suggested do this? Thanks again

[ranman256]

thats a harder way, when the way i suggested provides the solution. The way Access works.
If you want all sums at the footer, then you need a SUB report.
make a query to sum the shifts, put this sub report at the footer of the main reports.

[Bulzie]

Could you use DSum as the control source in the Report footer? Not sure what value you are summing or tablename or if there are other criteria for the data on the report.
MachineTotalA field:
= DSum("[Hours]", "tblMachineData", _
"[Machine] = 'A'")

MachineTotalB:
= DSum("[Hours]", "tblMachineData", _
"[Machine] = 'B'")

MachineTotalC:
= DSum("[Hours]", "tblMachineData", _
"[Machine] = 'C'")