Merging Data from two similar tables

[Wilf- OSP]

I have two tables with very similar information in each. These tables are
related to each other by the Record_ID.

1st Table
Record_ID, ####,####,####,####,Demand_Date,####,####,####

2nd Table
Record_ID, ####,####,####,####,Update_Date,####,####,####

New Table
Record_ID, ####, ####, ####, ####, ####, ####, ####, Demand_Date, Update_Date


These two tables are very similar 1st created record and 2nd updated record.
They both have missing data and need to merge the two together to create a
Whole record with missing data merged and both the Demand_Date and the
Update_Date are there.

Any Help is welcome….

 

[scubadiver]

What I would do is create an inner join between the two tables and create a
make-table query.

 

[Wilf- OSP]

I understand what you mean by an inner join, but not sure how this would
overcome where the data is missing in one and not in another? What would
happen?

Also, there are records that match with Primary key in one but there is not
always a record in the 2nd and vice versa. Not sure if this is clear enough.

Cheers for the help, Sam