Hello all, I have a form with a contol source of =DSum("total","qryQFF1stREC") if this dose not return a value I nee it to reurn a 0 so my other text boxes caculate correctly. Any Ideas?
Advanced Beginner
Windows 7 32bit 
Access 2010 32bit
Hello all, I have a form with a contol source of =DSum("total","qryQFF1stREC") if this dose not return a value I nee it to reurn a 0 so my other text boxes caculate correctly. Any Ideas?
Access Developer
Windows XP Access 2003
As a guess, try:
=Nz(DSum("total","qryQFF1stREC"),0)
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Advanced Beginner
Windows 7 32bit Access 2010 32bit
Thank you Thank you..... That did it!!
Query return 0 for null values
Return a value of zero for null queries
Posting Permissions
Reply With Quote