You can't have the query show a total at the end of a column. You can either have a query that totals the column or have a report that totals the column. To have a query total the column you need to Group your columns. There is a summation sign (big 'E') in the query editor. If you click on that you can group by your columns and sum columns. To find the total copies and Cost you will probably want to use Sum.
For a report, use you current query as the source for the report, then use the Report Footer to sum the Cost and Copies.