Enter Parameter Value - Custom Calculation In Report

[Faraz A. Qureshi]

I have a continuous/tabular form of report with two fields DEBIT & CREDIT
I have created two custom calculating controls in form of textboxes as
follows:
Name of control "DBALANCE"
=IIf([DEBIT]>[CREDIT],[DEBIT]-[CREDIT],0)
and
Name of control "CBALANCE"
=IIf([DEBIT]<[CREDIT],-[DEBIT]+[CREDIT],0)

They work perfectly, however, now, when I insert:
=SUM([DBALANCE]) &
=SUM([CBALANCE])
in the report footer to calculate the grand total the report on being turned
on asks for parameter value for
DBALANCE &
CBALANCE

Any reason and way to resolve?

 

[John Spencer]

You will have to repeat the calculation in the report footer controls. You
can SUM fields, you cannot SUM controls.

=SUM(IIf([DEBIT]>[CREDIT],[DEBIT]-[CREDIT],0))
and
=SUM(IIf([DEBIT]<[CREDIT],-[DEBIT]+[CREDIT],0))

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Daryl S]

Faraz -

Use these sums instead:

=SUM(IIf([DEBIT]>[CREDIT],[DEBIT]-[CREDIT],0))

=SUM(IIf([DEBIT]<[CREDIT],-[DEBIT]+[CREDIT],0))