How do I merge two access tables into a new table

[Chris]

I have two access tables with multiple data. I want one field from each of
these tables to update a like field in a third table if certain fields are
the same (in one of these two tables) with like fields in the third table.
Is there a way to do this without manually going through them and entering it
myself. I'm working with over 400 entries from these two tables and I need
one piece of data from both of these tables, put onto the third table.

 

[Tim Ferguson]

I have two access tables with multiple data. I want one field from
each of these tables to update a like field in a third table if
certain fields are the same (in one of these two tables) with like
fields in the third table.

Whatever this means, you don't want to do it. Copying columns of data from
one table to another is never necessary (except, of course, when you are
trying to mend a bad design) and suggests you have a Serious Design
Problem.

Perhaps if you posted some details of what you are meaning to achieve, we
could suggest something that would work.

B Wishes


Tim F