Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    99

    Unanswered: Sum createing minus number

    Good afternoon

    I have in an unbound text box control source

    Sum([FT]=True)

    this kind of works but appears to create a minus figure

    Any ideas

    Thank you

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    o the Access Gnomes, True is -1, hence your negative numbers. To display it as a positive number try using

    Code:
    =Abs(Sum([FT]=True))


    Linq ;0)>
    Last edited by Missinglinq; 10-06-13 at 10:12.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •