I am basing a report on a number of fields, some of which I want totals on. Is there any way to add a sum(field) to the footer of the report. Like adding a calculated field.
It seems to me it takes two queries to do this, but how do you base a report on two queries?
Thanks for help, R