Merging several tables

K

kikilag

I am a new user of Access (1- 6hr course under my belt) I have 5 very large tables of part numbers that I would like to merge into 1 table to eliminate the need to perform several queries - Is there a way to do this??
 
B

Bob Barnes

You could use Append Queries. BUT, be sure that in doing
this, fields being appended would not violate a Primary
Key value in the "receiving table".

HTH - Bob
-----Original Message-----
I am a new user of Access (1- 6hr course under my belt) I
Click to expand...
have 5 very large tables of part numbers that I would like
to merge into 1 table to eliminate the need to perform
several queries - Is there a way to do this??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Merging from an Excel file with graphics 1
Start a mail merge upon opening the document 1
ASK Field Formatting 1
Adding data to MS Access from csv file 0
List all tables, including document structure 0
Creating a Chart on form from selected data in query. 0
Populate a table based on check box status 2

Top