Calculating in Detail Ling

[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?

 

[John Spencer]

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