Help With Delete Query

[ttuguy]

Hello all, I am pretty new to Access and self taught and hoping you guys can help me out with a project I have taken on at work.

I am creating a database of inventory, services performed, pricing etc. I have 2 tables. 1 table is being imported from our current system via Excel to update the inventory on a daily/weekly basis. The 2nd table is used to input various services pricing etc.

What I need to do is delete old records from the 2nd table using the updated inventory table I import into Access. I have played around with it but cannot get it to work. Any ideas? The 2 tables are related using the unique inventory #. I need to delete values from Table 2 that do not show up on table 1 using the unique inventory #

 

[jdraw]

Access query wizard has a find unmatched query. Start with that to identify records in tableA that are NOT in TableB.

 

[ttuguy]

Thanks for your reply, after some playing around I got it to work. I started with the unmatched query as you suggested and then used those results for a delete query. Appreciate it!