Average in a Query
Posted on 2007-03-21
I am trying to calculate an average in a query, but I must be missing something in the syntax.
The table I'm working from has 7 columns - 1 "Name" column and 6 "Value" columns (V1, V2, etc). Some of the value columns may be zero. I have pulled all 7 columns into the query data fields.
My approach was to write an expression named "Average" in the 8th column in the query:
Unfortunately, this simply sums the values.