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" wrote in message
...
What do you mean by "normalized?"
"Duane Hookom" wrote:
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/O...p#Hookom,Duane.
Regarding your question about storing the average... you shouldn't.
--
Duane Hookom
MS Access MVP
"RTimberlake" wrote in message
...
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" wrote:
In an unbound field in your query or form.
--
Rick B
"RTimberlake" wrote in message
...
Where would I put that equation?
"Duane Hookom" wrote:
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" wrote in
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.