sum on a column of data in a query?

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

Guest

I have created a Select Query, I have 3 columns of data, I'm able to create
calculations on rows, but not columns???
 
Have you looked into the Totals queries? These are design to aggregate down
columns.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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
 
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


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
Click to expand...
Click to expand...
 
Back
Top