Enter Parameter Value - Custom Calculation In Report


F

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

Advertisements

J

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
 
Ad

Advertisements

D

Daryl S

Faraz -

Use these sums instead:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top