If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.