UpDate Query for Tables

[Guest]

I need to create an Update query that will get information from table 'A' which has 18 fields (total) and overwrite the information in table 'B' which has the same 18 fields and more. I do not want to lose any of the information in the fields of table 'B' that are not in table 'A'
IE -- Table A has 'Name' 'Salary' and Table B has 'Name' 'Salary' 'StartDate' for the people who has a salary change I would like to have an Update query to reflect the new Salary and keep the Start date

thank you!

Adam

 

[John Spencer (MVP)]

See my reply to you posting that was prior to this one by 25 minutes. HINT:
This is a volunteer forum and people aren't here all the time. It can take time
to get an answer. A couple of hours to a couple of days (although a couple of
hours is most usually the case).