brucerblack
New member
- Local time
- Yesterday, 20:14
- Joined
- Jul 18, 2017
- Messages
- 2
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!
imgur . com/a/k6j5E (sorry cant post links yet )
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!
imgur . com/a/k6j5E (sorry cant post links yet )