Partial Report footer sum

  • Thread starter Thread starter Raul Sousa
  • Start date Start date
R

Raul Sousa

I have a report with several movementType and there respective values.
At the footer of each MovementType (type A, Type B, Type C) I have a sum.
Now at the report foot I want to calculate type B – TypeC.
How can I do this?
 
Raul said:
I have a report with several movementType and there respective values.
At the footer of each MovementType (type A, Type B, Type C) I have a sum.
Now at the report foot I want to calculate type B – TypeC.
Click to expand...


A quick and dirty way is to use text boxes with expressions
like:
=Sum(IIf(MovementType = "A", valuefield, 0))

But that will be troublesome if you ever need to add/remove
a type or change the name of an existing type.

A robust solution to your problem would be to create a
Totals type query that calculates the totals. Then use the
query as the basis for a small report and use it as a
subreport in your current report.
 
Back
Top