Access 2007
My OS is windows 7 and I use Access 2007. I have 2 tables, Table A and Table B.
Both table's structure are the same. In Table A, in addition to the ID field it also has a field called ACS Keyline. While table B has the same field, but there are no data as the User had exported the Table but excluded this field. How do I update Table B with the ACS Keyline field from Table A, when the ID fields in Table A and Table B are equal. The data structure in both tables of the ID are identifical. Hope my problem makes sense. Please give me the steps on how to achieve them hopefully be as basic as possible. Thank u.
Both table's structure are the same. In Table A, in addition to the ID field it also has a field called ACS Keyline. While table B has the same field, but there are no data as the User had exported the Table but excluded this field. How do I update Table B with the ACS Keyline field from Table A, when the ID fields in Table A and Table B are equal. The data structure in both tables of the ID are identifical. Hope my problem makes sense. Please give me the steps on how to achieve them hopefully be as basic as possible. Thank u.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER