title: MS-Access : How to sum multiple values from different tables according to dates
body: <p>I have two similar tables as follows</p>
  <hr />
  <h2>Table 1<br></h2>
  <pre><code>Date           Amount     Tax
  4/1/2016       1000       100
  4/1/2016       2000       200
  5/3/2016       1500       150
  5/6/2016       1000       100
  5/6/2016       3000       300
  7/9/2016       2500       250
  </code></pre>
  <hr />
  <h2>Table 2<br></h2>
  <pre><code>Date           Amount     Tax
  4/1/2016       1000       100
  4/2/2016       3000       300
  5/3/2016       1500       150
  5/9/2016       4000       400
  8/11/2016      3000       300
  10/9/2016      2000       200
  </code></pre>
  <p>dates can be similar or different in both tables.<br>
  I want two queries. <br>
  First, a query which gives me sum of amount and tax from each date from both tables between required dates. Eg: Table 1 have 2 entries and table 2 have 1 entry for 4/1/2016. so the result should be as below (summing up all three entries)<br></p>
  <pre><code>Date           Amount     Tax
  4/1/2016       4000       400
  4/2/2016       3000       300
  5/3/2016       3000       300
  5/6/2016       4000       400
  5/9/2016       4000       400
  7/9/2016       2500       250
  8/11/2016      3000       300
  10/9/2016      2000       200
  </code></pre>
  <p>Second,a query which gives of sum of amount and tax for each month from both tables between required dates. Eg output as below</p>
  <pre><code>Date           Amount     Tax
  4/2016         4000       400
  5/2016        11000      1100
  7/2016         2500       250
  8/2016         3000       300
  10/2016        2000       200
  </code></pre>
  <p>Query that have I have written till now( not working )</p>
  <pre><code>SELECT date, sum(Amount),sum(Tax)
  From Table1
  WHERE Date BETWEEN #04/01/2016# AND #12/31/2016#
  UNION ALL
  SELECT date, sum(Amount),sum(Tax)
  From Table2
  WHERE Date BETWEEN #04/01/2016# AND #12/31/2016#
  GROUP BY Date
  </code></pre>