title: MS Access, passing the total of all outstanding loans to a query to find the percentage of loans outstanding to the total loans for each record
body: <p>I am fairly new to MS Access so I'll share all pictures and share what I have come up with so far.</p>
  <p>I have records of  sales agents with loans sold and outstanding loans balances. I want to be able to calculate the outstanding loan balance per agent over the total outstanding balances, taking into consideration the days the loan has been in arrears. I have managed to split the original source data using queries into two tables, Loans in arrears above 15 days and 13 days.</p>
  <p><a href="https://i.stack.imgur.com/TDakO.png" rel="nofollow noreferrer">Loan in Arrears Above 15 Days</a></p>
  <p>I would like a simple efficient way to be able to get the total outstanding balances for all the agents then find the percentage each agent contributes to the total i.e.</p>
  <p>= (individual loan balances 15 days in arrears)/total outstanding loan balances</p>