S
SLM
I have created a Select Query, I have 3 columns of data, I'm able to create
calculations on rows, but not columns???
calculations on rows, but not columns???
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.
J
Jeff Boyce
Have you looked into the Totals queries? These are design to aggregate down
columns.
Regards
Jeff Boyce
Microsoft Office/Access MVP
columns.
Regards
Jeff Boyce
Microsoft Office/Access MVP
J
JethroUK©
I think that's the problem - aggregate functions work recordwise - not
fieldwise - i have same instance of 18 fields need adding together & apart
from [field1] + [field2] + [field3], ad nausium - there doesn't seem to be
anyway of summing a collection of fields
fieldwise - i have same instance of 18 fields need adding together & apart
from [field1] + [field2] + [field3], ad nausium - there doesn't seem to be
anyway of summing a collection of fields
J
Jeff Boyce
You are describing ... a spreadsheet! A relational database
(well-normalized) doesn't use "repeating fields". So you really wouldn't
expect to find a function in Access that gives you an easy way to "sum
across columns", since that's more a spreadsheet function...
Regards
Jeff Boyce
Microsoft Office/Access MVP
(well-normalized) doesn't use "repeating fields". So you really wouldn't
expect to find a function in Access that gives you an easy way to "sum
across columns", since that's more a spreadsheet function...
Regards
Jeff Boyce
Microsoft Office/Access MVP
JethroUK© said:I think that's the problem - aggregate functions work recordwise - not
fieldwise - i have same instance of 18 fields need adding together & apart
from [field1] + [field2] + [field3], ad nausium - there doesn't seem to be
anyway of summing a collection of fields
Jeff Boyce said:Have you looked into the Totals queries? These are design to aggregate down
columns.
Regards
Jeff Boyce
Microsoft Office/Access MVP