I get #Error in a simple =sum([Field1]) calcualtion in a
form's footer. Identical formula works in another identical
form. What could be a reason for the formula to error, and
what are common causes for #Error in Access forms?

Very much appreciate the help! Deadline tomorrow morning, and I can't figure it out!