Dawn You seem to be getting quite weird problems with your database. If the formula is in the control footer or the report footer and the control source is valid the formula should work i.e. If Num_Unit_Facility_01 is a valid control source (check the underlying table) and the formula is placed in the Num_Unit_Facility_01 footer you should get the correct answer unless there is something wrong with your Access.
Looking at your question again you say that you have created the formula in the Control Source of your Sum_Num_Unit_Facility_01 field. This is not clear at least to me. You place the formula in the control's footer on the report and not in the Control Source. Perhaps I don't understand the question. Regards Liveson ----- Original Message ----- From: dawnmahc To: [email protected] Sent: Thursday, 02 April, 2009 19:55 PM Subject: [ms_access] Sum formula not working in the Control Source Hello everyone, I'm pretty new to MS Access. I've created the following formula in the Control Source of my Sum_Num_Unit_Facility_01 field: =Sum([Num_Unit_Facility_01]) I'm getting the #Error message. I cannot figure out why this would be happening. It seems like this would be the easiest formula in the world. Can someone please help me? Thank you in advance. Dawn [Non-text portions of this message have been removed]
