Append Query totals into a report

[Exhausted]

Pls help. I will try and explain my problem.

I have a report that is printed from a Macro through forms.

It selects and runs 4 different append queries, posting data into a table. The $ amount from the table is reported on the report but what I can't do is get the 4 different $ to total up. I would like to be able to have a Sum at the bottom of the page.

Any suggestions or ideas would be greatly appreciated. I hope I've given you enough info to go on. I'm using Access2003 and I didn't create this database, but am trying to tidy up - a beginner that likes a challenge!

Thanks in advance.

 

[ezfriend]

Can you create a text object on the report and set its control source to "=sum([TheFieldThatYouWantToSum])"

 

[Exhausted]

Yes, I've tried that and get nothing.

The report shows the individual figures but no totals. All other reports with totals I've created are fine.

After the data / report is populated and printed it removes the data from the last query created and leaves the table empty again. I don't see this as a problem but just trying to see if you can make any sense of it.

So:
Query 1 is run, appends 1 field in table data
Query 2 is run, appends 2 fields in table data
Query 3 is run, appends 0 fields in table data.
Query 4 is run, appends 0 fields.
3 fields are shown on report, with Name, T/No & Amount. I'm trying to total the amount overall.

Cheers for your help.