title: Create table in Access vba and populate with results from query
body: <p>I am working on an access 2010 database and needs some help.</p>
  
  <p>I am trying to create some vba code that will run a query and then create and populate a table based on the records returned.  I then want to rename the table based on a value from the query (company name).</p>
  
  <p>I have the query built that will return distinct values from my table, but I need to create a seperate table for each company that is returned in the results.</p>
  
  <p>Any and all suggestions are appreciated.</p>