Finding values in a table that are not in another table

[Accessbeginner23]

Good morning,



I am creating a database and importing records from an Excel spreadsheet. I imported records from the spreadsheet and have since added other records to the table. The columns in the spreadsheet were Model #, Serial #, etc. Now after I have created the table in Access and imported that information, I have decided that it would be nicer to create another table with all of the model numbers, brand name of equipment, etc. and then have a look up column in the main table point to the model number table. I imported all of the model numbers from the spreadsheet into my database and then ran a query eliminating the duplicate model numbers. My problem is that when I try to create the look up column from the tblequipment table to the tblModelNo table, it gives me an error message saying the it can't be created because there are records in one of the tables that don't match records in the other table. What kind of query do I need to create to find the values that don't match?

I hope I've given enough information and don't sound to confusing.

Thanks

[JoeM]

You want an "Unmatched Query". Take a look at the "Find Unmatched Query Wizard" in Access. It will walk you through setting up an Unmatched Query.