Summing Text Boxes

  • Thread starter Thread starter Haji
  • Start date Start date
H

Haji

Hello,

I have four text boxes on a subform all with currency
values. The text box names are Q1_Sales_2003,
Q2_Sales_2003, Q3_Sales_2003 and Q4_Sales_2003. I want
to create another text box that sums the values from the
other four text boxes. How do I do this?

Thanks,

Haji
 
Set the textbox's ControlSource to
=Nz(Q1_Sales_2003,0) + Nz(Q2_Sales_2003,0) +
Nz(Q3_Sales_2003,0) + Nz(Q4_Sales_2003,0)

Hope This Helps
Gerald Stanley MCSD
 
Gerald,

Thanks for you help. I am getting an invalid syntaxt
error when I entered your expression into the control
source of my new text box. The message says that I am
omitting an operand or operator or I have entered an
invalid character or comma. Any thoughts?

Thanks,

Haji
 
Haji

Nothing springs to mind. I would suggest that you try
building the expression incrementally i.e. set it to
=Nz(Q1_Sales_2003,0) and test that before setting it to and
testing =Nz(Q1_Sales_2003,0) + Nz(Q2_Sales_2003,0) and so on.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top