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
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.