Results 1 to 4 of 4
  1. #1
    Join Date
    May 2013
    Posts
    56

    Unanswered: Summing Negative Currency

    How do I sum negative currency values in a query? The result is always the last record that I added.

  2. #2
    Join Date
    Nov 2011
    Posts
    413
    =Sum(IIf([yourfieldname]<0,[yourfieldname],0))

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you may well need a group by clause

    alternatively consider using the domain function dsum

    if you neeD to sum the negative and positive values seaprately thenmake that part of th domAin criteria or where clause if using native sql
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    May 2013
    Posts
    56

    Summing Negative

    I am trying to use the group by clause. Thanks

Posting Permissions

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