Access #error in microsoft access

[Cornel]

Hi guys, i need ur help.
Microsoft access.
It's hard for me to fix #Error in my total textbox. I did read many blog and web to solve this.
Most answer bout this problem is on that name, but it doesn't work.
Btw, i make balance sheet report (for financial statement).
Then, total shows #error.

Help me please.
Thankyou

 

[Becky]

Have you checked whether there's an error in your balance sheet (ie the figures not the calculations)?

 

[BarberSmurf]

Could you show the formula in the textbox ? Via your photos, it seems that you are trying to put the sum textbox in the page footer, instead of the report footer. This may be the reason why it causes an error. Please try to put it in the report footer section (not the page footer).