Avatar of Derek Brown
Derek Brown
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

How to create queries that lookup information in other queries or tables.

Hi All
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?
Microsoft Access

Avatar of undefined
Last Comment
Derek Brown

8/22/2022 - Mon