Calculating in Detail Ling

  • Thread starter Thread starter Ripper
  • Start date Start date
R

Ripper

I have a subReport based on a Crosstab Query totaling up the number of
students that test in multiple catagories. I am attempting to calculate a
sum at the end of each detail that will only add 2 of the 3 values together.
I attmeted to use =sum([TAKS]+[TAKS-Acc]).

I get the total of All the detail sections instead of just the sum from that
detail line. Is there some way to just total the single line?
 
Don't use SUM just add the values
=[TAKS]+[TAKS-Acc]

IF either value is blank (null) then the result will be blank (null).
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top