Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries
Queries
Resolved · Low Priority · Version 2003
Queries
How can you create queries to split up tables and create new tables?For upcoming training course dates see: Pricing & availability
RE: Queries
Hi KaraA 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
Fri 28 Nov 2008: Automatically marked as resolved.
|
|
» Forum post: Custom functions |



Course updates

