New Contributor

Hi All!


I'm getting a #Error on my report on the "Total Use" control when there haven't been any visits to the pantry for that month. I've tried using the Nz function thinking I could force the null value to a 0 with no luck.


I'm having a hard time nailing down the source of the problem. 


I'll include a couple of screen shots. Hopefully that helps!



2 Replies
best response confirmed by kmarler18 (New Contributor)
You Sum() it in the Report Footer not in Detail or Page Footer.
It worked! Thank you! I'm still confused as to why it didn't work before putting it in the Report Footer? Can you help my dumb monkey brain understand? ;o)