Assigning Values to TextBoxes

P

Public

Hi,
I am generating a report that have several values. What I want is the
summation of these values into one textbox (like calculating the total). I
have tried using '+' operation in my text box but it didn't work.

Any ideas?
 
J

John Spencer

Summing in one record

Set control source to
= Nz(Field1,0) + Nz(Field2,0) + Nz(Field3,0)
Make sure the control name is NOT the same as any field name

Summing one field in many records (in a group footer)
Control Source: =SUM(FieldA)

If these don't work for you, please post back with an explanation of
what you tried and what you mean by "does not work". Did you get an
error message (what was it), the wrong results (why are the results
"wrong"), or some other problem.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Top