Still Learning - Query to join 2 tables & more

[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.

 

[Mike Painter]

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.

One way is to create a copy of the 20 field table (to be safe)
Open both tables in design view, then cut and paste the fields from the ten
field table into the 20 field table.
Then do an update query on your new table based on the query you want.

You could also give other names to the tablename.fieldname format using
AClearName:tablename.fieldname in the query.
The order is determined by the query.