Hi folks! I've been looking around everywhere and get the same answer, but somehow it doesn't work.
I run a query that has a sum total. If the total value is "nothing" i want the default value to be 0.
I want this because i have a form that displays the calculated value, but if it's empty, my whole form goes blank (so does the query).
I read everywhere about the Nz expression. But it doesn't return 0 in any case possible and my problem remains. Please help!
What am i doing wrong here? Thanks in advance!