Group Total On Report Error

[txaccess]

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!

 

[hymn]

You could try
'Sum([Field1])
'Sum([Field2])
'Sum([Field3])
xxx= field1a+field2a+field3a

fielda etc = name of text box created for sum

Hope this helps
Hymn