why do I get just the sum with Avg([column1]+[column2]...)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

why do I get just the sum with Avg([column1]+[column2]...) and how do I avoid
trunacation of my formulas?
 
"The Dummy in Access for Dummies" <The Dummy in Access for
(e-mail address removed)> wrote in message
why do I get just the sum with Avg([column1]+[column2]...) and how do I
avoid
trunacation of my formulas?
Click to expand...

Because you are just looking at one record, and, just guessing here, your
field is not wide enough. If you click on the line between columns in QBE
view you will see <|> which means that you can drag and expand the column.

you want (col1 + col2 + ...+ coln) /n to claculate the average. The average
function averages over rows not columns.
 
I did use the long hand version and it worked, as long as I only use column1
to column12...but after that, the expression builder trunacates the rest of
my formula...this is why I was hoping to use the Avg() and StDev() function.
Any ideas on how to approach this....column1=an item...column2-column13=sales
per month...I wanted to add a column14 and column15, to show the average and
standard deviation for each item (row) in the query design.
 
The Dummy in Access for Dummies <The Dummy in Access for
why do I get just the sum with Avg([column1]+[column2]...) and how do I avoid
trunacation of my formulas?
Click to expand...


Access is a Database, not a spreadsheet. Your data
structure is going to drive you crazy as you try to do more
things in your project. Please do yourself a favor and
Google for Database Normalization to learn how to structure
data in a more reasonable way.
 
Back
Top