Tony2021Iron ContributorDec 24, 2021Balance query 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 q...Show MoreBalanceFacility.zip27 KB
arnel_gpIron ContributorDec 25, 2021Tony2021 you create a query that will Total the draws (group by ProjID).join this new query to your qryBalance. BalanceFacility.zip28 KB
Tony2021Iron Contributor to arnel_gpDec 25, 2021amazing. I see what you did and understand it. thanks for the help!
Tony2021Iron Contributor to arnel_gpDec 25, 2021amazing. I see what you did and understand it. thanks for the help!
