I have data in a table that holds a list of components that make up an engine assembly. I have Thirteen columns: Make, Model, Block, Cylindar Head, Camshaft, Gearbox and Driveshaft. I have a reference number for each part and a single date field indicating when the information is entered. I then have "Current Prices Tables" for each of the five items holding description and part number and I need a query to collect the current prices from each table using the reference number from each part. The thing that really throws it all is that the data (without prices) is pasted into the main table from Excell. Will a query be able to automate the process of attaing a total price for the assembly?