Sum three fields "on the fly" & place results on form 2

[Sherman6789]

Is there a simple way to have three fields automatically calculated (summed) with the results displayed on a form. The results will be "on the fly" and not stored. The answer will change whenever any of the three fields are changed. The reports will do all of the other calculations and reports.

Thanks for any help you can give.

 

[VRoscioli]

Create a textbox, label, etc. and set its ContorlSource property to

=[[i]Field1[/i]]+[[i]Field2[/i]]+[[i]Field3[/i]]

-V

 

[traingamer]

Or:

=Val([Field1])+Val([Field2])+Val([Field3])

so you get 5 + 6 + 7 = 18 rather than = 567

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill