By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,660 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,660 IT Pros & Developers. It's quick & easy.

calculate row level statistics?

P: 3
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.microsoft.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.
Feb 14 '17 #1

✓ answered by Seth Schrock

Assuming that the all the fields involved are numeric types (integer, double, etc.), then the format would be something like this within your query:
Expand|Select|Wrap|Line Numbers
  1. (Field1 + Field2)/Total_Field As Percentage_Field

Share this Question
Share on Google+
5 Replies


Seth Schrock
Expert 2.5K+
P: 2,941
Assuming that the all the fields involved are numeric types (integer, double, etc.), then the format would be something like this within your query:
Expand|Select|Wrap|Line Numbers
  1. (Field1 + Field2)/Total_Field As Percentage_Field
Feb 14 '17 #2

P: 3
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 11222230021221131225221215553, 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_Opening]+[ScriptedClosing]+[Gathered_Email]+[Gathered_Address]+[Gathered_First_Name]+[Gathered_Last_Name]+[Gathered_Phone]+[Verified_Address]+[Verified_Email]+[ContactPermission]+[Correct_Data_Entry]+[Hold_Two]+[Hold_Permission]+[Thanked_Holder]+[Warm_Transferred]+[Correct_Dispo]+[Built_Rapport]+[Positive_Communication_Interaction]+[Phone_Etiquette]+[Professional_Conduct]+[Accurate_Info]+[Call_Control]+[Verified_AB]+[Verified_IEPSEP]+[Next_Steps]+[Needs_Assessment]+[Plan_Recommendation]+[Asked_Sale]+[Overcame_Objections])
Feb 14 '17 #3

Seth Schrock
Expert 2.5K+
P: 2,941
Then at least one of those fields must be a text field and not numeric.
Feb 14 '17 #4

P: 3
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!!!
Feb 14 '17 #5

Seth Schrock
Expert 2.5K+
P: 2,941
You're welcome. Good luck on your project.
Feb 14 '17 #6

Post your reply

Sign in to post your reply or Sign up for a free account.