Partial Report footer sum

[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?

 

[Marshall Barton]

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.

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.