Comparing Access Tables 1

[Kinca]

I have 2 Access tables that I created from 2 different Excel Spreadsheets. Table A is the Master. I need to compare Table B to Table A and identify the records from Table B that DO NOT exist in Table A. Can someone let me know how to do this?

 

[BNPMike]

Pull both tables into the QBE screen. Join them on the key. Now make the join B-to-A a left outer join using the join line editor. Then select all the records that have a key value in A that has the WHERE criterion of IS NULL.