Results 1 to 4 of 4

Thread: Dsum Problem

  1. #1
    Join Date
    Oct 2003
    Location
    Is
    Posts
    21

    Unanswered: Dsum Problem

    i have a tabel with the valus:

    [movetype] [PaySum]
    + 1
    + 2
    - 3


    I Made a textbox = dsum("paysum","Tblemp",movetype="+") and instead the result will be 3 the result is 6

    Need some help fast!!
    Last edited by orenz; 11-02-03 at 13:19.
    Oren Zzz

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    dsum("paysum","Tblemp",movetype="+")
    the third argument also needs to be a string

    does this work for you?
    dsum("paysum","Tblemp","movetype='+'")

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Oct 2003
    Location
    Is
    Posts
    21

    Talking TNX..

    It worked the problem was in the third argument like you said...

    However now i want to sum the value of + and the - .
    I made field sum = [SumP]-[SumM]

    WHERE
    SUMP= dsum(,,+)
    SUMM=dsum(,,-)

    But if there is no value in one of those field, the sum field is Null. So i cant see only the SumP or SumM in the sum field...

    ???
    Last edited by orenz; 11-03-03 at 10:40.
    Oren Zzz

  4. #4
    Join Date
    Oct 2003
    Location
    Is
    Posts
    21

    ?????

    Oren Zzz

Posting Permissions

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