A "total row" is something you will find in a form or report, but not
a query. To get these values in a query, you would typically need a
separate query for the totals.
Alternatively, you can paste the values into a spreadsheet and add
totals to that.
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts