Getting a Negative Value in a Sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I use the following expression =Sum([Service Provider
Participation]="Yes") in a report I get the right number but with a negative
(-) in front of it? Appreciate any ideas.
 
Nick,
I gather that [Service Provider Participation] is a "Yes/No" field. If that
is the case then you need to realize that real value behind a "Yes" in that
field is -1. Therefore, since you are only asking for the sum of the "Yes"
values, you will always get a negative number. Try the following instead.

=Abs(Sum([Service Provider Participation]="Yes"))

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Back
Top