title: Report containing sums from different queries in Access
body: <p>I am currently working with different tables and queries in Access and I can't find a way to do something very simple. I have the following :</p>
  
  <ul>
  <li>Two queries, qry1 and qry2</li>
  <li>One table, tbl1</li>
  </ul>
  
  <p>Both queries and the table have a "NET" field of type float (or double)</p>
  
  <p>What I'd like to do is create a very simple report which would give me the total of the NET column for each of those three objects. I have tried to insert a text box in a blank report and selecting sum(NET) on qry1 in Control Source but it doesn't work, it simply prints '#Error' with no more information.</p>
  
  <p>If I use 'Add Existing field' and drag&amp;drop 'NET' from tbl1 and then edit it to add sum it works but it is repeated for each row which is obviously not what I want. It feels like I'm missing something here or that I might not be using the right tool.</p>
  
  <p>Thanks in advance for your help!</p>