Hi guys,
I'm trying to compare "Table B" to "Table A" to see what records in "Table B' are not in "Table A" and delete them. "Table A" is a linked table thats updated daily from an external source, and "Table B" is a table populated by a query in which the user supplies an account number, and the rest of the matching info is taken from "Table A" into "Table B" to be worked. Since "Table A" is constantly changing, I need a query or vba to compare the two tables, and remove any records from "Table B" that no longer appear in "Table A". Any ideas??
**edit**
Problem Solved: With just a LITTLE BIT more searching, I found this: http://office.microsoft.com/en-us/access/HA102051321033.aspx#1
and that worked for me!
I'm trying to compare "Table B" to "Table A" to see what records in "Table B' are not in "Table A" and delete them. "Table A" is a linked table thats updated daily from an external source, and "Table B" is a table populated by a query in which the user supplies an account number, and the rest of the matching info is taken from "Table A" into "Table B" to be worked. Since "Table A" is constantly changing, I need a query or vba to compare the two tables, and remove any records from "Table B" that no longer appear in "Table A". Any ideas??
**edit**
Problem Solved: With just a LITTLE BIT more searching, I found this: http://office.microsoft.com/en-us/access/HA102051321033.aspx#1
and that worked for me!
Last edited:
