So i have two large tables of data - in fact linked excel spreadsheets that hold serial number for equipment one table hold xx manufacture and the other another xxx manufacture both tables have the sam field name i want to use
Manufacture_Date
Serial_Number
Last_ImpectionDate
need to have all the data in one new query so i can pull in this data using just the Serial Number but have just one pass against all data
Manufacture_Date
Serial_Number
Last_ImpectionDate
need to have all the data in one new query so i can pull in this data using just the Serial Number but have just one pass against all data