Hello All, I'm still in the learnig stage using Microsoft Access 2003 The issue I'm having is this: I have 2 tables 1. Master 2. Scanned Master contains 3 fields (ID, UPC, Price) Basically the Master table is a table that contains all UPC's and accosiated prices for a store. The Scanned tabled contains 2 fields (ID, and Scanned_UPC) Basically the scanned table is a table that represents all items with a UPC in the store. I want to do a query to compare all the items under the "Scanned_UPC" field in the Scanned table against the "UPC" field in the master table. And give me a result with the "UPC" and the "Price" in a third table. I appreciate any help... I'm all confused by this.