Thread: Averages?
View Single Post
  #4  
Old September 12th, 2005, 06:17 PM
Rick B
external usenet poster
 
Posts: n/a
Default

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.