Need help on AVERAGING

[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.

[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*********@cox.net> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.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.