Thread: Averages?
View Single Post
  #3  
Old September 12th, 2005, 04:29 PM
RTimberlake
external usenet poster
 
Posts: n/a
Default

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.