How can you create queries to split up tables and create new tables?

Hi Kara

A Make table query allows you to take data from an existing table in query form and then create a new table. To do this:

1. Create a query from the table you want to split holding the fields you want to go in the first table.

2. Click the Query Types button on the toolbar and select Make-Table Query...

3. Enter the new table's name in the Table Name text box

4. Click OK and then save the query

5. When you run the query it will create the new table you require.

6. Repeat for the rest of the data in the original table

Hope this helps

Carlos