Access calculation not calculating correct

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

I have a calculation in the control source for the Total Cost with Subsidy
field as :
=((Nz([Quarterly_Cost],0))-(Nz([QuarterlySubsidy],0))*(Nz([BuyBackCreditQuarters],0))).
It is not calculating correctly. The amounts are:
Quarterly Cost = $1500.00
Quarterly Subsidy = $450.00
Buy Back Credit Quarters = 13
Total Cost with Subsidy = (should be $13650.00) but it is giving me a
negative value of ($4,350.00).
I didn't see anything is the database coded wrong but I could have over
looked. Do you see anything in the calculation that I have wrong?

Thanks
 
Noel,

You've got too many parenthesis, try:

=(Nz([Quarterly_Cost],0)-Nz([QuarterlySubsidy],0))*Nz([BuyBackCreditQuarters],0)

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top