Re: Getting a Negative Value in a Sum

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



"Nick" <Nick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2AEFD1DD-6222-4966-BF9E-C32FC0593917@xxxxxxxxxxxxxxxx
> 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.


.

Relevant Pages

  • Re: How to refresh an MDW ?
    ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ... Prev by Date: ...
    (microsoft.public.access.security)
  • Re: extra table required?
    ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Design Assistance Needed
    ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Move secured DB to shared folder, now it wont open
    ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ... Prev by Date: ...
    (microsoft.public.access.security)
  • Re: many to many problem
    ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)