Thanks for the reply. I guess I'm not understanding as this is new to me. Can this be done with a Criteria statement in the Access query? Where the query compares the two tables and returns all line items except those where the serial number is a certain number? Sorry for my ignorance on this.

I have an Access 2016 table with several columns, one of which is a column SerialNumberExc lude. I want to compare data from another table and if the serial number in this table matches any serial number in the SerialNumberExc lude, I want to exclude those records in my query. hope that's not too confusing. I'm only YouTube University qualified with Access! LOL

**Additional info: Serial numbers are a text format and are entered...