? Sum Instead Of Count

T

Tru

I am using the following code to count the different [BillType] in a control
on my report:

=Sum([BillType]="2")

The count is correct but the number is negative ( "-4 records" instead of "4
records")
 
T

Tru

Rick, Thanx Again Big Guy
--
Thanx!


Rick B said:
Then use the absolute value...

=Abs(Sum([BillType]="2"))

--
Rick B



Tru said:
I am using the following code to count the different [BillType] in a control
on my report:

=Sum([BillType]="2")

The count is correct but the number is negative ( "-4 records" instead of "4
records")
Click to expand...
Click to expand...
 
Top