Calculated Field in form

[Tuckejam]

sorry if this seems like a double post, I know it is closely related to my "Calculated Column" post in queries. but I have other issues with forms as well

I have a simple math problem

FineAmount - AmountPaid = AmountDue

in the form (subform) I have totaled the the amounts in the subform footer

Total Fines	Total Paid	Amount Due
=Sum([qry_Fines]![FineAmount])	=Sum([qry_Fines]![AmountPaid])	????????

whats really odd is when i use this formula in the amount due textbox =sum( [FINEtotal] - [FINEpaid] )

it voids the other two formulas in Total Fines and Total Paid and all 3 boxes return #ERROR

How can I get the form to do the simple math of A-B=C

Thanks for the help

[accesstos]

Total Fines: =Sum([FineAmount])
Total Paid: =Sum([AmountPaid])
Total Due: =Sum([FineAmount])-Sum([AmountPaid])

[Tuckejam]

That Worked! Thank You!!! (and I understand the layout better now, I still always think of formulas in excel format)

bonus question: with the other formula, why did it error out the other two "total" and "Paid" fields just by simply referencing them in the formula?

[accesstos]

That Worked! Thank You!!! (and I understand the layout better now, I still always think of formulas in excel format)

You are welcome!

bonus question: with the other formula, why did it error out the other two "total" and "Paid" fields just by simply referencing them in the formula?

Sorry, I have no idea!...

[ArviLaanemets]

bonus question: with the other formula, why did it error out the other two "total" and "Paid" fields just by simply referencing them in the formula?

The formula must work when you refer to form controls instead, like = Nz(txtTotalFines,0) - Nz(txTotalPaid,0). And remember, when any field/control is empty, the formula returns an error unless you take care of it - I used Nz() in my example here for this.