total of line items not working

[Guest]

My line items in a form are totaled for each row. I have a total of the line
items in the footer - except that I get #error instead of the result. My
line item totals are calculated by:
=nz([intQuantity],0)*(nz([curPrice],0)*(1-nz([dblDiscountPercent],0)))

My footer total is calculated (in theory) by
=Sum(nz([intQuantity],0)*(nz([curPrice],0)*(1-nz([dblDiscountPercent],0))))

I copied these right out of Access 2003 Bible. I don't understand why the
footer calc is not working.

In my troubleshooting, I copied the text from the lineamount to the total
box in the footer. It then provided a result that matched which ever line
item I clicked on. From there I added the "sum" and additional parantheses.
Then it worked and gave the proper answer. However, if I changed any value
in the line item (such as discount) or if I closed the form and reopened it,
I was back to the #error. I have checked and rechecked and even renamed the
text box. It does not share a name.

 

[Steve Schapel]

Papa Jonah,

Since you are still having this problem, and since no-one else has had a
go, I guess we go for broke here. If it was mine, the next thing I
would do is compact & repair the database. If the problem persists, I
would make a new form, and copy all of the controls from your existing
troublesome form onto the new one. And also any code will have to be
copy/pasted or re-done. See if that helps! If the problem still
persists, take 2 aspirin and go to bed.