Report Sums

[pbrown2]

In the report there are fields [Old or New] and [Plant]. [Plant] is the main grouping then [Old or New] (currently set only with a footer) divides the plant into, either "old" or "new" areas for totals. This allows to have a total amount for Old and a total amount for New within each Plant.
What I need now is for at the end of the report, a grand total for "Old" and a grand total for "New" along with the complete grand total.

i.e.
Plant 1
Old 23
New 24
Plant total 47
Plant 2
Old 21
New 25
Plant total 46

Grand Old 44
Grand New 49
Grand Total 93


Does anyone know how I would do this?

Thank you for any and all help,

PBrown

 

[buhgman33]

The easiest way to do this is this:
In the menu goto view and select Report Header/Footer. This will diplay these sections in you report design veiw. Copy the fields you have for the totals of each plant (Old, New, Total) into the report footer. This should work.

 

[JPMontreal]

Hi,

Create a subReport base on a query, that do the total without grouping, and add it at the end of your report.

jp@solutionsvba.com


Jean-Paul
Montreal
mtljp2@sympatico.ca