I created a query in Microsoft Access such as the one below:

```
SELECT LoanType
,Avg(Loan Amount)
,Avg(Loan Rate)

FROM Table1
GROUP BY LoanType

```

The output is as you would expect, the average loan amount and the average loan rate for each loan type.

However, I'd like for my Access Report to calculate the average of all the loans, regardless of loan type, and place this row at the very bottom. Using the Report view in Access, you can add a "Totals" row where you can write a formula such as COUNT(), SUM(), AVG(). But as you know, calculating an average of an average goes against basic math. 

I'm assuming I have to create this "Totals" row at the SQL/Query level. But I can't seem to figure it out. Any input would be greatly appreciated!