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...
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
