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 n...
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
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