Averages?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Where would I put that equation?

Duane Hookom said:
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
--

RTimberlake said:
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.
Click to expand...
Click to expand...
 
In an unbound field in your query or form.

--
Rick B



RTimberlake said:
Where would I put that equation?

Duane Hookom said:
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
--

RTimberlake said:
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.
Click to expand...
Click to expand...
Click to expand...
 
If I do that will I be able to save the figure in a table so it can be
accessed later?


--Rebecca


Rick B said:
In an unbound field in your query or form.

--
Rick B



RTimberlake said:
Where would I put that equation?

Duane Hookom said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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.

Rick B said:
In an unbound field in your query or form.

--
Rick B



RTimberlake said:
Where would I put that equation?

Duane Hookom said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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


RTimberlake said:
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.

Rick B said:
In an unbound field in your query or form.

--
Rick B



RTimberlake said:
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.
Click to expand...
Click to expand...
Click to expand...
 
What do you mean by "normalized?"

Duane Hookom said:
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


RTimberlake said:
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.

Rick B said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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
--

RTimberlake said:
What do you mean by "normalized?"

Duane Hookom said:
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


RTimberlake said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top