Calculating in Detail Ling

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ripper - 28 Apr 2008 21:35 GMT

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?

Signature

Thanks As Always
Rip

Reply to this Message

John Spencer - 29 Apr 2008 13:30 GMT

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

> 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
[quoted text clipped - 3 lines]
> 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?

Reply to this Message