Balance query

[Tony2021]

hello Experts,

I have 2 tables.

tblFacility

tblDraws

I want to develop a query that will show the tblFacility.Amount - sum of tblDraws.Amount

I thought it would be as simple as making a sum query but I seem to be doing it wrong (I get an aggregate function error).  Not sure what I am doing wrong?  Please see attached db with the 2 tables and the query.  thank you for the help. 

[#2]

@Tony2021 

you create a query that will Total the draws (group by ProjID).

join this new query to your qryBalance.

[#3]

amazing. I see what you did and understand it. thanks for the help!