calculate row level statistics? - Microsoft Access / VBA

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

Subscribe Post Reply

✓ 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

(Field1 + Field2)/Total_Field As Percentage_Field

1125

Seth Schrock

2,965

Expert 2GB

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

(Field1 + Field2)/Total_Field As Percentage_Field

Feb 14 '17 #2

taytay

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

2,965

Expert 2GB

Then at least one of those fields must be a text field and not numeric.

Feb 14 '17 #4

taytay

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

2,965

Expert 2GB

You're welcome. Good luck on your project.

Feb 14 '17 #6

Similar topics

Graphs/statistics using wxPython

by: Jan Danielsson | last post by:

Hello all, I wanted to plot some statistics, so I wrote a simple wxPython class to do it. Then I realized that I would like to draw bar graphs, so I added that too. Since I'm a complete...

Python

Generating various statistics from data in MSSQL7

by: Justin Lebar | last post by:

Sorry about the huge post, but I think this is the amount of information necessary for someone to help me with a good answer. I'm writing a statistical analysis program in ASP.net and MSSQL7 that...

Microsoft SQL Server

UPDATE STATISTICS necessary to improve performance (?)

by: Felix | last post by:

Dear Sql Server experts: First off, I am no sql server expert :) A few months ago I put a database into a production environment. Recently, It was brought to my attention that a particular...

Microsoft SQL Server

Forcing auto-update statistics to fire in SQL Server 2000

by: Jerry Brenner | last post by:

Our users have potentially dirty legacy data that they need to get into our application. We provide a set of staging tables, which map to our source tables, that the users do their ETL into. ...

Microsoft SQL Server

Database Statistics... Best way to maintain stats???

by: Lucas Tam | last post by:

Hi all, I have an application which logs a considerable amount of data. Each day, we log about 50,000 to 100,000 rows of data. We like to report on this data... currently I'm using a stored...

ASP.NET

statement-level statistics are disabled error (postgresql.conf)

by: Campano, Troy | last post by:

Do you know what I did wrong? I'm trying to enable some logging features in postgresql.conf, but now I get this message when I try to connect to the postgresql server... WARNING: ...

PostgreSQL Database

Automatic statistics update

by: Chris Weston | last post by:

Hi. I have automatic statistic update turned on for all my databases. Is this an overhead I can do without? Could I update them overnight when the database is hardly in use? Thanks --...

Microsoft SQL Server

Collecting different execution statistics of C++ programs

by: romixnews | last post by:

Hi, I'm facing the problem of analyzing a memory allocation dynamic and object creation dynamics of a very big C++ application with a goal of optimizing its performance and eventually also...

C / C++

Row Level Statistics

by: Topflite66 | last post by:

I am working on an Access 2003 database that I need to do calculations accross several columns on a single row. I found this link in an earlier post: http://support.microsoft.com/?kbid=209839 ...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA