T
The Dummy in Access for Dummies
why do I get just the sum with Avg([column1]+[column2]...)
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
Duane Hookom
Are you attempting to average fields across a single record? Adding columns
across generally suggests an un-normalized table structure. How about
providing some sample values and desired results.
across generally suggests an un-normalized table structure. How about
providing some sample values and desired results.
T
The Dummy in Access for Dummies
Sure...in a table...column1=Item...column2-column13=sales per month. In query
design, I wanted to add a column14 and column15 to have the average and stdev
for each item (row). I though that all I needed to do was enter
Avg([column2]+...[column13]) and then run the query for the average sales
that year for each row.
design, I wanted to add a column14 and column15 to have the average and stdev
for each item (row). I though that all I needed to do was enter
Avg([column2]+...[column13]) and then run the query for the average sales
that year for each row.
D
Duane Hookom
It doesn't work that way. You are creating a spreadsheet. Either move your
data to Excel or maybe normalize so that the month value becomes a value in
a Mth field rather than a column in a table. Once your table is normalized,
you can easily create averages and standard deviations.
If you can't change your table structure, create a union query that
normalizes. Use the union query as the source for a totals query.
--
Duane Hookom
MS Access MVP
"The Dummy in Access for Dummies"
data to Excel or maybe normalize so that the month value becomes a value in
a Mth field rather than a column in a table. Once your table is normalized,
you can easily create averages and standard deviations.
If you can't change your table structure, create a union query that
normalizes. Use the union query as the source for a totals query.
--
Duane Hookom
MS Access MVP
"The Dummy in Access for Dummies"
Sure...in a table...column1=Item...column2-column13=sales per month. In
query
design, I wanted to add a column14 and column15 to have the average and
stdev
for each item (row). I though that all I needed to do was enter
Avg([column2]+...[column13]) and then run the query for the average sales
that year for each row.
The Dummy in Access for Dummies said:why do I get just the sum with Avg([column1]+[column2]...)