Combine Data?

[CTOROCK]

I have two tables with peoples names, Acct #'s, Date and Amount Paid,. One table has a little more fields than the other. Some of the records from table 2 are found in table 1, but does not have all the data needed to be a complete for the record.
In other words the record is in both places and they both have needed data to be merged

I want to create a query that will place the records from table 2 that are not in table 1 and then i want to fill in the missing data in table 1 from table 2.

 

[mflancour]

Wow, I tried to think of some kind of union query that might do all this....hurts my brain though.

Could u update a 3rd table with info from both, that would work. Course you would have that 3rd table then, but if you do all this in code you can create-update-use-then delete the table with no one being the wiser.

 

[THoey]

This going to have to be done with multiple queries. I think I might first add the missing records and then perform an update query to update the missing data. Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...