Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: quick function help.

    Here is my function.

    =nz(DSum("[CountInvFaao]","[tbl Page 5 Inv ET]","[Date_in_inv] Between #5/1/2004# And #5/31/2004#"),0).

    This works fine.
    Is there a way that I can add two dsum functions together?

    Ex.

    =nz(DSum("[CountInvFaao]","[tbl Page 5 Inv ET]","[Date_in_inv] Between #5/1/2004# And #5/31/2004#"),0)+(DSum("[CountInvFaao]","[tbl Page 5 Inv EET]","[o_maty] Between #5/1/2004# And #5/31/2004#"),0)

    Thanks!

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    probably,

    but in your first example, you have a correct:
    nz(stuff,0)

    in your second example you have an erroneous:
    nz(stuff1,0)+(stuff2) ...and a lost ",0" --- the nz already closed.

    perhaps
    nz(stuff1, 0) + nz(stuff2, 0)
    ?

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Mar 2004
    Posts
    361
    I justed added the nz and it worked. 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
  •