SUM Question

fenhow

Registered User.
Local time
Today, 12:18
Joined
Jul 21, 2004
Messages
599
Hi, I have a form with 4 txtBoxes on it.

txt1, txt2, txt3, txt4

I want to add an unbound txtbox that shows the sum of txt1,2,3,4.

Is this possible?

Thanks.

Fen How
 
Sure; try:

=txt1 + txt2 + txt3 + txt4
 
To avoid an error caused by nulls I would use

=Nz([txt1],0) + Nz([txt2],0) + Nz([txt3],0) + Nz([txt4],0)
 

Users who are viewing this thread

Back
Top Bottom