Totaling 3 fields

K

Kelly

I have 3 fields in my form...I want to add them and total them in another
field...I tried an unbound box and the total keeps giving me the entire
amount in the database...I just want the amount in that one record...
 
D

Dale Fye

Kelly,

I assume you mean you have four controls on this form, three which are bound
and the fourth which is unbound.

I'll assume that these are named txt_Field1, txt_Field2, txt_Field3, and
txt_Field4, and that the underlying field names are (Field1, Field2, and
Field3). In the Control source of txt_Field4 enter: = [Field1] + [Field2]
+ [Field3]

HTH
Dale
 
Top