title: Append Query - Multiple Tables into Single Table
body: <p>I have 8 queries all with the same design etc to make a new table but for different criteria's and would like to append them into one single table. </p>
  
  <p>Is there any way with VBA code or possibly UNION to do this?</p>
  
  <pre><code>SELECT tbl_SCCMQ.CONTRACT_ACCOUNT_NUMBER, tbl_SCCMQ.BP_Partner, tbl_SCCMQ.CONTRACT_NUMBER, tbl_SCCMQ.BILL_TO_DATE, tbl_SCCMQ.CONTRACT_START_DATE, tbl_SCCMQ.AGEING_DATE, tbl_SCCMQ.DateDiff, tbl_SCCMQ.PAYMENT_TYPE, tbl_SCCMQ.BP_Type, tbl_SCCMQ.[Next Bill Due Date], tbl_SCCMQ.[BAND], tbl_SCCMQ.RAG, tbl_SCCMQ.BILL_STATUS INTO tbl_01_Resi_CCQ_R1_4_Never_Billed_NoSS
  FROM tbl_SCCMQ
  WHERE (((tbl_SCCMQ.BP_Type)="B2C") AND ((tbl_SCCMQ.RAG) Like "R*") AND ((tbl_SCCMQ.BILL_STATUS)="First") AND ((tbl_SCCMQ.BILL_BLOCK) Is Null) AND ((tbl_SCCMQ.BILL_LOCK) Is Null) AND ((tbl_SCCMQ.INVOICE_LOCK) Is Null));
  </code></pre>
  
  <p>Here are two tables,</p>
  
  <pre><code>qry_01_Resi_CCQ_R1_4_Never_Billed_NoSS
  
  qry_02_SME_CCQ_R1_4_Never_Billed_NoSS
  </code></pre>
  
  <p>and would like them all importing into main table "Data"</p>
  
  <p>I am quite new to Access and VBA etc.</p>