textbox running sum calculation fail

  • Thread starter Thread starter Tarvirdi
  • Start date Start date
T

Tarvirdi

Dear friends,
I have a table with fields A,B.
in report design I have Textbox for fields A & B. good, works well
Now I want a column with running sum of fields [A]+. so I dropped
a textbox and set RUNNING SUM=Over All and set
CONTROL SOURCE= [A]+ but it doesn't work!!!
if I change controlSourec=[A] works well but I want above calculation
what should I do?
Thanks
Tarvirdi
 
Tarvirdi said:
Dear friends,
I have a table with fields A,B.
in report design I have Textbox for fields A & B. good, works well
Now I want a column with running sum of fields [A]+. so I dropped
a textbox and set RUNNING SUM=Over All and set
CONTROL SOURCE= [A]+ but it doesn't work!!!
if I change controlSourec=[A] works well but I want above calculation
what should I do?
Thanks
Tarvirdi
Click to expand...


You are including the "=" right? Your ControlSource should look like...

=[A]+

If both fields are numeric, then I see no reason why that would not work.
 
Except if A or B are Null at some point.
= Nz([A],0) + Nz(,0)



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


Rick said:
Tarvirdi said:
Dear friends,
I have a table with fields A,B.
in report design I have Textbox for fields A & B. good, works well
Now I want a column with running sum of fields [A]+. so I dropped
a textbox and set RUNNING SUM=Over All and set
CONTROL SOURCE= [A]+ but it doesn't work!!!
if I change controlSourec=[A] works well but I want above calculation
what should I do?
Thanks
Tarvirdi
Click to expand...


You are including the "=" right? Your ControlSource should look like...

=[A]+

If both fields are numeric, then I see no reason why that would not work.
Click to expand...
 
Back
Top