Row of averages or totals at the bottom of a query

[BRZ-Ryan]

I am using the below query, I'd like the query to have a row at the bottom to display the totals and\or averages for each column.

SELECT Col1, Col2
FROM tblTest
WHERE (TimePeriod=#Jan 2015#)
ORDER BY TimePeriod;

ie.

COL1	COL2
43	1
22	22
12	43
77 (total)	66 (total)

[ranman256]

you cant do both, thats a report.

but for a query, you can have Q1 to show the data
Q2 to do sum and avg of Q1
Q3 as a union query of: Q1 union Q2.