Question about Sum() function

  • Thread starter Thread starter tao lin
  • Start date Start date
T

tao lin

Hi,

I am using Ms Access 2000 sp3 under winXP Pro.

In my report has 4 text box.
Name Control source
Visible
----------------------------------------------------------------------------
---------------------------------
1. CommissionShare CommissionShare
No - From Query's Field
2. NeedCal NeedCal
Np - From Query's Field
3. RealCommission =IIf([NeedCal]=-1,[CommissionShare],0) Yes
4. TotalCommission =Sum([RealCommission]) Yes
Runing Sun=Over All

What I try to do is put a Sum in my report footer base on the text box
'RealCommission'. But when I preview the report, Access ask me to input the
value of RealCommission. It looks like Sum() function only support the
field come from the Query, not from a caculate text box. Or do I have
something wrong in my RealCommission Control source expression?

Cheers,

Tao
 
You are correct. For TotalCommission, you need to redo the calculation

TotalCommission = Sum(IIf([NeedCal]=-1,[CommissionShare],0))
 
Back
Top