I have a report with a grouping on Record Owner. There is a line on the report that shows a series of number. When I come to add up the series in the group footer using the Sum() argument, I get the following error;
"The Expression 'Sum([Field1]+[Field2]+[Etc.]) is invalid
Aggregate functions are only allowed on output fields of the Record Source"
All of the fields are direct from the underlying query and are not derived from any others. Can anybody tell me how I can total this report?
Thanks in advance.
I haven't failed, I have just found 10,000 ways that it won't work!
"The Expression 'Sum([Field1]+[Field2]+[Etc.]) is invalid
Aggregate functions are only allowed on output fields of the Record Source"
All of the fields are direct from the underlying query and are not derived from any others. Can anybody tell me how I can total this report?
Thanks in advance.
I haven't failed, I have just found 10,000 ways that it won't work!