Search results

If you are having summing multiple columns, or just using math functions, check the columns for NULL or missing values. In those cases, just write iif statements, or nesting iif statements to account for those. I would account for the NULLs prior to the summary query, whenever possible.

I am late to this answer, but in my case the error was caused by object naming-having the same name for a form and table. So, if anyone else has this issue, review all the object names. Cheers