BASE REPORT WRITER How to add the Total of a column in footer

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

Do this in Report Builder not query. Steps & sample on this post.

Thanks much, I now see what a text box can do!!

R

@kasloman: It sounds like this answer helped, so please mark the answer correct, as explained in guidelines for asking.

If this answers your question please tick the :heavy_check_mark: (upper left area of answer). It helps others to know there was an accepted answer.