I am attempting to sum multiple columns in one row. So there is an ID for a quality form, and then there are aspects of the quality form that I want to add together and then divide by the total score possible to create a percentage. The other articles I have read stated that this is referred to as calculating row level statistics and pointed towards http://support.microso ft.com/?kbid=209839 but there is nothing on that site any longer. Most of the expressions I have tried in my query have returned errors... and one simply listed all the numbers in a long row instead of summing them. I am a newbie to access so any help would be greatly appreciated.
-
-
Assuming that the all the fields involved are numeric types (integer, double, etc.), then the format would be something like this within your query:Code:(Field1 + Field2)/Total_Field As Percentage_Field
-
So I tried it like that- starting out to just see if the sum will work properly (see below). It adds the brackets in after I went to the datasheet to view. What ends up showing in the data field is 112222300212211 31225221215553, which is all of the values I am attempting to add, rather than summing each of the values. I'm not sure what I'm doing incorrectly..
Expr1: ([Scripted_Openin g]+[ScriptedClosing]+[Gathered_Email]+[Gathered_Addres s]+[Gathered_First_ Name]+[Gathered_Last_N ame]+[Gathered_Phone]+[Verified_Addres s]+[Verified_Email]+[ContactPermissi on]+[Correct_Data_En try]+[Hold_Two]+[Hold_Permission]+[Thanked_Holder]+[Warm_Transferre d]+[Correct_Dispo]+[Built_Rapport]+[Positive_Commun ication_Interac tion]+[Phone_Etiquette]+[Professional_Co nduct]+[Accurate_Info]+[Call_Control]+[Verified_AB]+[Verified_IEPSEP]+[Next_Steps]+[Needs_Assessmen t]+[Plan_Recommenda tion]+[Asked_Sale]+[Overcame_Object ions])Comment
-
Then at least one of those fields must be a text field and not numeric.Comment
-
omg you're right--- idk how many times i reentered that expression and didn't think about that being an issue... thank you soooo much!!!Comment
-
You're welcome. Good luck on your project.Comment
Comment