Averages?

[RTimberlake]

I know that there is a way to calculate averages in Access. But, where do you
put the equation and how should it look. I need to get the average of three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as show up
on my form.
Any help that you can give would be greatly appreciated.

 

[Duane Hookom]

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average, use
=([Communication] +[Decision Making] + [Observation])/3

 

[RTimberlake]

Where would I put that equation?

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average, use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

I know that there is a way to calculate averages in Access. But, where do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as show
up
on my form.
Any help that you can give would be greatly appreciated.

 

[Rick B]

In an unbound field in your query or form.

--
Rick B

Where would I put that equation?

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average, use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

I know that there is a way to calculate averages in Access. But, where do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as show
up
on my form.
Any help that you can give would be greatly appreciated.

 

[RTimberlake]

If I do that will I be able to save the figure in a table so it can be
accessed later?


--Rebecca

In an unbound field in your query or form.

--
Rick B

Where would I put that equation?

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average, use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

I know that there is a way to calculate averages in Access. But, where do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as show
up
on my form.
Any help that you can give would be greatly appreciated.

 

[RTimberlake]

One more question...Is there a way to pull the information from three table
entries to form one average?
It may help you to know what I am trying to accomplish. I am creating a
database for employee evaluations. We have three people fill out the
evaluation. At the end I need a report to give me the averages of the three
evaluations. I hope this makes sense.

In an unbound field in your query or form.

--
Rick B

Where would I put that equation?

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average, use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

I know that there is a way to calculate averages in Access. But, where do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as show
up
on my form.
Any help that you can give would be greatly appreciated.

 

[Duane Hookom]

I wouldn't go any further until the application was normalized. There is a
good starting point in the sample employee evaluation at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Regarding your question about storing the average... you shouldn't.

--
Duane Hookom
MS Access MVP

One more question...Is there a way to pull the information from three
table
entries to form one average?
It may help you to know what I am trying to accomplish. I am creating a
database for employee evaluations. We have three people fill out the
evaluation. At the end I need a report to give me the averages of the
three
evaluations. I hope this makes sense.

In an unbound field in your query or form.

--
Rick B

Where would I put that equation?

:

If your table was properly normalized, you would use a totals query
that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the
average, use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

message
I know that there is a way to calculate averages in Access. But,
where do
you
put the equation and how should it look. I need to get the average
of
three
feilds in my table. They are named: Communication, Decision Making
and
Observation. I want this average to be stored in my table as well
as show
up
on my form.
Any help that you can give would be greatly appreciated.

 

[RTimberlake]

What do you mean by "normalized?"

I wouldn't go any further until the application was normalized. There is a
good starting point in the sample employee evaluation at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Regarding your question about storing the average... you shouldn't.

--
Duane Hookom
MS Access MVP

One more question...Is there a way to pull the information from three
table
entries to form one average?
It may help you to know what I am trying to accomplish. I am creating a
database for employee evaluations. We have three people fill out the
evaluation. At the end I need a report to give me the averages of the
three
evaluations. I hope this makes sense.

In an unbound field in your query or form.

--
Rick B



Where would I put that equation?

:

If your table was properly normalized, you would use a totals query
that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the
average,
use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

message
I know that there is a way to calculate averages in Access. But,
where
do
you
put the equation and how should it look. I need to get the average
of
three
feilds in my table. They are named: Communication, Decision Making
and
Observation. I want this average to be stored in my table as well
as
show
up
on my form.
Any help that you can give would be greatly appreciated.

 

[Duane Hookom]

Did you look at the demo I posted? I would not use Communication, Decision
Making, and Observation as field names. The demo uses them as values in a
field. Each individual rating creates a record in a table rather than having
a multiple field table.

The normalized solution is easier to maintain since you can add evaluation
points without having to change table structures, forms, reports,....

--
Duane Hookom
MS Access MVP
--

What do you mean by "normalized?"

I wouldn't go any further until the application was normalized. There is
a
good starting point in the sample employee evaluation at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Regarding your question about storing the average... you shouldn't.

--
Duane Hookom
MS Access MVP

One more question...Is there a way to pull the information from three
table
entries to form one average?
It may help you to know what I am trying to accomplish. I am creating a
database for employee evaluations. We have three people fill out the
evaluation. At the end I need a report to give me the averages of the
three
evaluations. I hope this makes sense.

:

In an unbound field in your query or form.

--
Rick B



Where would I put that equation?

:

If your table was properly normalized, you would use a totals
query
that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the
average,
use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

message
I know that there is a way to calculate averages in Access. But,
where
do
you
put the equation and how should it look. I need to get the
average
of
three
feilds in my table. They are named: Communication, Decision
Making
and
Observation. I want this average to be stored in my table as
well
as
show
up
on my form.
Any help that you can give would be greatly appreciated.