Merging 2 tables

[dusencha]

I have 2 tables. There is similar data in each table. Example - patient name, date.

Do I use Append to merge the data or do I use another feature?

One table contains:

• Patient Name
• Admit ID
• Date

Second table contains:

• Patient Name
• Admit ID
• Date

But then each table also contains a few fields that are different.

[amrut]

I would suggest to create a third table with required fields and then append data to this table from these two tables and fix up duplicates.

[Xipooo]

Yes, an append query is what you want... and amrut is right. Insert them into a 3rd table.