importing from another table new fields 1

[usfpjc]

I have an Access Data Base that has been updated with another table.
The new table contains two new fields that I want to import to the main table.

I have tried with an "append query", but the fields wind up at the end of the table, and not positioned with the records to which they belong.

What may I be doing wrong?

 

[fkegley]

You need to build two new fields in the MAIN table to contain the fields from the NEW table. You will also need to have a common field in the two tables so that you can build a relationship between them. Then do an UPDATE query where you update the fields in the MAIN table with the corresponding values in the NEW table. Frank kegley
fkegley@hotmail.com