Forum Discussion

kmarler18's avatar
kmarler18
Copper Contributor
Jun 11, 2022

#Error

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!

 

access
  • arnel_gp's avatar
    arnel_gp
    Jun 12, 2022
    You Sum() it in the Report Footer not in Detail or Page Footer.
  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    Jun 12, 2022
    You Sum() it in the Report Footer not in Detail or Page Footer.
    • kmarler18's avatar
      kmarler18
      Copper Contributor
      Jun 13, 2022
      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)

Resources