Avoiding #Error in Microsoft Access 2007

[fifothekid]

Hi everybody,
I made a primitive cost control database system using Microsoft Access 2007 as a front-end (don't ask my why did I use Microsoft Access!!!) and SQL Server 2005 Enterprise as a back-end
This program depends on regrouping data, so I have sections and each section in front of it has the total of it's item
Everything is working smoothly, except that the last line in any list, which is empty, gives me #Error in calculated controls
What should I do to avoid that?

Thank you...

[puppydogbuddy]

You did not provide much info......see if this link helps:

http://allenbrowne.com/RecordCountError.html