RE: Create Table Query

Hi Chris

The Make Table Query allows you to take an existing Access table and split from it a group of fields you want to appear in a new table. To do this

1: Select Create on the ribbon and Select Query Design

2: Select the Table(s) or queries you want to use to create the new table. Click Ok

3: Create the query by dragging the fields you want to use from the field list into the design grid. Use any criteria (eg all dates after 1/1/00) to define the data to be moved to the new table.

4: Click Make Table in the Query Type section if the ribbon

5: Use the Table Name box to name the table you want to create.

6: Use Current Database or Another Database to indicate where you want to put the new table. Click OK

7: When completed create the new table by clicking Run on the Ribbon.

The newly created table should appear in the Tables area of the database

Hope this helps

Carlos