T
The Dummy in Access for Dummies
why do I get just the sum with Avg([column1]+[column2]...) and how do I avoid
trunacation of my formulas?
trunacation of my formulas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
why do I get just the sum with Avg([column1]+[column2]...)
D
David F Cox
"The Dummy in Access for Dummies" <The Dummy in Access for
[email protected]> wrote in message
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.
[email protected]> wrote in message
why do I get just the sum with Avg([column1]+[column2]...) and how do I
avoid
trunacation of my formulas?
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.
T
The Dummy in Access for Dummies
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.
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.
M
Marshall Barton
The Dummy in Access for Dummies <The Dummy in Access for
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.
why do I get just the sum with Avg([column1]+[column2]...) and how do I avoid
trunacation of my formulas?
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.