F fenhow Registered User. Local time Today, 12:09 Joined Jul 21, 2004 Messages 599 Oct 20, 2009 #1 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
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
pbaldy Wino Moderator Staff member Local time Today, 12:09 Joined Aug 30, 2003 Messages 36,279 Oct 20, 2009 #2 Sure; try: =txt1 + txt2 + txt3 + txt4
boblarson Smeghead Local time Today, 12:09 Joined Jan 12, 2001 Messages 32,059 Oct 20, 2009 #3 To avoid an error caused by nulls I would use =Nz([txt1],0) + Nz([txt2],0) + Nz([txt3],0) + Nz([txt4],0)
To avoid an error caused by nulls I would use =Nz([txt1],0) + Nz([txt2],0) + Nz([txt3],0) + Nz([txt4],0)
