Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Queries
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Queries
Resolved · Low Priority · Version 2003
Reply
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 |
Hi
