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

    Unanswered: Need to show null value

    I have about 12 text boxes that have a function that resembles this.

    =DSum("[CountClp1]","[tbl Page 5 Summary ET]","[Date_in_inv] Between #5/1/2004# And #5/30/2004#

    Following that function, I have another text boxs that performs a calc which looks like this

    =([txtClp1JunEt]/11).

    If the top function returns a 0 then the other function returns a 0 as well. What I need it to have the bottom function return a 0 so when I sum all 12 I can get a value. Right now 2 out of the 12 have 0's and when I sum them I don't get a value. I hope that made sense. Thanks for the help.

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    If the top function returns a 0 then the other function returns a 0 as well. What I need it to have the bottom function return a 0
    It allready does what you want it to do???

    Guessing from the title of your post this is not what you mean ....

    Solution to your title:
    Use NZ

    Either:
    =nz(DSum("[CountClp1]","[tbl Page 5 Summary ET]","[Date_in_inv] Between #5/1/2004# And #5/30/2004#),0)

    or


    =(nz([txtClp1JunEt])/11)

    Regards

  3. #3
    Join Date
    Mar 2004
    Posts
    361
    Sweet. That worked perfectly. I don't know if I would have ever figured that out. Thanks!

  4. #4
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Using the Access helpfiles is an art in itself

    Regards

Posting Permissions

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