Need help on AVERAGING - Microsoft Access / VBA

Rotten Spice

Hello all,

I am still pretty new to Access but I do have a grasp on some basic
functions.

I am having a problem with averaging and I think I'm trying to do
something a little too complex and maybe I even have it set up wrong.

I am putting some evaluation forms online. Each form/table is
different, apart from the first 10 questions which are the exact same
on all 5.

I have 5 tables: tbl1, tbl2, tbl3, tbl4 and tbl5.

The similar fields are Behavior1, Behavior2... Behavior10, but to
differentiate between the tables they have prefixes such as PMBehavior,
PSBehavior, VABehavior etc.

I need to be able to take PSBehavior1, PMBehavior1, VABehavior1 etc for
one particular person and find the average.

So if they got a 4,3,3,4 and 2 the average for Behavior question #1
would be 3.2 and it would show up in my web-based report.

But with it being 5 different tables, I am clueless as to how to get an
average from that.

Any help would be greatly appreciated.

Nov 13 '05 #1

Subscribe Reply

2199

David Lloyd

I have a couple observations. One possible approach is to create a inner
join between the five tables and then create a calculated field (or fields)
in which you calculate the average (or averages).

A second approach would be to combine all the common questions in one table
and create an additional field to distinguish which of the five evaluations
it belongs to. You could then create a GROUP BY query on each person and
calculate the average using the AVG function. This is probably the easier
approach.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Rotten Spice" <ro*********@co x.net> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com...
Hello all,

I am still pretty new to Access but I do have a grasp on some basic
functions.

I am having a problem with averaging and I think I'm trying to do
something a little too complex and maybe I even have it set up wrong.

I am putting some evaluation forms online. Each form/table is
different, apart from the first 10 questions which are the exact same
on all 5.

I have 5 tables: tbl1, tbl2, tbl3, tbl4 and tbl5.

The similar fields are Behavior1, Behavior2... Behavior10, but to
differentiate between the tables they have prefixes such as PMBehavior,
PSBehavior, VABehavior etc.

I need to be able to take PSBehavior1, PMBehavior1, VABehavior1 etc for
one particular person and find the average.

So if they got a 4,3,3,4 and 2 the average for Behavior question #1
would be 3.2 and it would show up in my web-based report.

But with it being 5 different tables, I am clueless as to how to get an
average from that.

Any help would be greatly appreciated.

Nov 13 '05 #2

Similar topics

2458

Need help with programming

by: Sofia | last post by:

My name is Sofia and I have for many years been running a personals site, together with my partner, on a non-profit basis. The site is currently not running due to us emigrating, but during its last year we got traffic of between 2000 - 2500 unique visitors per day. We are now about to re-launch the site from Sweden and we need to purchase a script to run it. Having looked at what is available on the net I have realised that we need a...

PHP

2186

Need help getting hello-world working

by: Robert Maas, see http://tinyurl.com/uh3t | last post by:

System login message says PHP is available, so I tried this: http://www.rawbw.com/~rem/HelloPlus/h.php It doesn't work at all. Browser just shows the source. What am I doing wrong?

PHP

2442

Need help to tree-ify nested parenthesis...

by: Gregory Nans | last post by:

hello, i need some help to 'tree-ify' a string... for example i have strings such as : s = """A(here 's , B(A ) silly test) C(to show D(what kind) of stuff i need))""" and i need to parse them to have a tree representation such as :

Python

4389

by: Mike Kamermans | last post by:

I hope someone can help me, because what I'm going through at the moment trying to edit XML documents is enough to make me want to never edit XML again. I'm looking for an XML editor that has a few features that you'd expect in any editor, except nearly none of them seem to have: 1 - Search and repalce with Regular Expressions. 2 - Search and Replace in an Xpath context. 3 - User specified tag-generation for either on a...

.NET Framework

2843

need help deriving from the std::list class

by: JustSomeGuy | last post by:

I need to write an new class derived from the list class. This class stores data in the list to the disk if an object that is added to the list is over 1K in size. What methods of the std stl list class must Ioverride in order for this to work?

C / C++

3496

Doing crosstab query - need info from current week only for 1 field

by: Tina | last post by:

My employer tracks productivity/performance of clinicians (how much they bill) each week, its averages for the month, and the 6 months. These averages are compared to their expected productivity. However, the expectation changes - it may be 60% for a while, then change to 50%. Initially, I was averaging the expectation, along with the productivity, but what I'm being asked is to look at the average productivity/performance compared to...

Microsoft Access / VBA

3958

Brilliant technology helping those most in need

by: U S Contractors Offering Service A Non-profit | last post by:

Brilliant technology helping those most in need Inbox Reply U S Contractors Offering Service A Non-profit show details 10:37 pm (1 hour ago) Brilliant technology helping those most in need Inbox Reply from Craig Somerford <uscos@2barter.net> hide details 10:25 pm (3 minutes ago)

C / C++

1986

Averaging Data Rows in Access

by: JJ R | last post by:

I am trying to develop a simple and efficient to calculate averages. For example I want to calculate the averages of the Values for rows 1 and 2 and use ID 1 as the row with the average result. Table Exmple ID Value1 Value2 Value3 1 2 3 1 2 5 4 32 3 4 45 6 4 12 78 12

Microsoft Access / VBA

1701

Averaging Errors

by: Kid Programmer | last post by:

Hello guys. Whenever I am learning a new programming language I like to learn the basics (variables, loops, conditionals etc) by writing a program that will calculate averages. I wrote a simple number averaging program. But when I run it in Eclipse or the command line and I enter: 1 3 5.5 It says the average is 3.1666666666666665 when it should be 3.1666666666666667. I checked and am positive it is dividing the sum by 3. What do I...

Java

8984

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8823

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9530

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9363

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9312

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9238

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8237

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4864

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2206

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General