title: Multiple Queries in One Report - MS Access
body: <p>To keep this simple, lets say I have two tables. </p>
  
  <p>The first is called <strong>Employees</strong>. It contains an <em>id</em> field and an <em>employee_name</em> field. </p>
  
  <p>The second is called <strong>Pay</strong>. It contains an <em>id</em> field, an <em>employee_id</em> field and an <em>amount</em> field.</p>
  
  <p>Now, I want to run a report on <strong>Pay</strong> that shows me how much each employee got paid by showing me only the <em>Employee.employee_name</em> and the <em>Pay.amount</em>. </p>
  
  <p>Obviously, I'm going to have to take the <em>employee_id</em> field from the <strong>Pay</strong> table and match it up with the the <em>id</em> field from <strong>Employees</strong>, but I have no idea how to do that.</p>
  
  <p>I know a little VBA and am pretty knowledgeable with SQL, but MS Access has me so confused I'm about to kill myself. I hate Access so much, I want to take it outside behind the middle school and get it dead.</p>
  
  <p>This seems like a relatively easy problem, so someone has to know how to do this. Any help would be hugely appreciated.</p>