Average of values in several fields

  • Thread starter Thread starter Herman
  • Start date Start date
H

Herman

I would like to calculate in a query the average of
numbers in several fields (Result 1, Result 2 etc.)
from one table.
I know that the function 'Avg' is available, but
somewhere I am doing something wrong.
Who can help me?

Thanks,

Herman
 
Dear Herman:

One of the "rules of normalization" is not to have repeating values
across the columns of a table or query. It is this mistake that
commonly causes the difficulty you have here. Redesign so the Result
values are in separate rows, so you can use the Avg (and other)
agregate functions as they were designed to be used.

A way to correct this temporarily is a UNION query that creates a
normalized appearance. I would need more details of your situation to
be specific.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top