textbox running sum calculation fail

[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

 

[Rick Brandt]

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

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.

 

[John Spencer]

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
'====================================================

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

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.