#Error

[kmarler18]

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 · Accepted solution]

You Sum() it in the Report Footer not in Detail or Page Footer.

[#3]

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)