Subtracting multiple objects from total object field

[Guest]

I am trying to subtract payments from a total contract field. I have 5
payment fields and the 1st 4 subtract fine but the last field doesnt change
my balance field. I have tried both afield named balance and anunbound text
box for myanswer field

 

[John Vinson]

I am trying to subtract payments from a total contract field. I have 5
payment fields and the 1st 4 subtract fine but the last field doesnt change
my balance field. I have tried both afield named balance and anunbound text
box for myanswer field

If you have five FIELDS in your table for five payments... your table
structure is incorrect.

You're assuming that we know what your tables look like, and how you
are calculating the balance. We don't. You can see your database; we
cannot.

Please post a description of your table's structure (just name the
relevant fields) and indicate how and where you are doing the
subtractions.

John W. Vinson[MVP]

 

[Guest]

Thanks for your reply but I solved my problem.Your right though I dont have
the table structure correct, I trying to insert a new form into a completed
db so without going through more than nesc. I created a quickversonusing 5
payment fiels p1-p5. I did this because we never recieve more than 5 payments
for this particular billing account. Thanks for your interest and if I decide
to go the correct route I will probably have more questions as I have only
programed in Paradox (before OLE)