Balance query

Question

hello Experts,I have 2 tables.tblFacilitytblDraws&nbsp;I want to develop a query that will show the tblFacility.Amount - sum of tblDraws.AmountI 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).&nbsp; Not sure what I am doing wrong?&nbsp; Please see attached db with the 2 tables and the query.&nbsp; thank you for the help.&nbsp;&nbsp;&nbsp;

arnel_gp · Answer

Tony2021&nbsp;you create a query that will Total the draws (group by ProjID).join this new query to your qryBalance.&nbsp;

tony2021 · Answer

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

Forum Discussion

Balance query

2 Replies

Resources