Newbie, I am

[Guest]

Have 2 tables I want to join to make 1 table in order to append records so as to create a single table. Table one has 30 fields and table two has 10 fields.

I want the 10 fields from the 2nd table to be inserted into table 1 starting from fields 10-20 followed by the balance of the fields from table 1. Both tables have the same unique identifer (primary key)

I did the standard Query which did return the information but not in order that I want. Plus, the field and file names were displayed as one name - way to confusing to review.

Would appreciate all suggestions on how to combine tables in desired field sequence with correct names of fields

 

[Steve Schapel]

CB,

I suppose the first point to make is that in normal database usage,
tables are not seen, so the order in which the fields appear is irrelevant.

Nevertheless, here is a reasonably straightforward way to achieve your
purpose...
1. Make a new table with the structure that you want to end up with,
which, if I understand you correctly, will be a table with 40 fields.
(By the way, this is an unusually high number of fields to have in a
table, and may indicate that your design is not as it should be...
please post back with examples of your fields and the data if you would
like to look into this aspect).
2. Make a new Query in design view, and add both your existing tables,
and join them as required on the primary key field
3. Make this into an Append Query (select Append from the Query menu),
and nominate your newly created table when prompted for the table to
append to.
4. Add all the fields from both tables to the query design grid, and
then go through them all and enter the applicable field in the new table
in the Append To row of the grid to indicate which of the existing
fields should go into which of the fields in the new table.
5. Run the query (click the button on the toolbar with the red ! icon),
and you should end up with pretty much what you are trying to achieve.