In my Access (2010) database, I have 4 linked tables (from other Access databases) that I would like to feed into one table, or query. I've tried using the query design but can't seem to get it right. Each table has the following columns:
Date, ColorID, PartCategory, PartSubcategory, MilThickness, Painter, Paint Line, Pre/Post Cure, Reading Number, Inspector, Time.
Like I said before I would like to be able to see the data records of all 4 linked tables in one table or query, but I would need instructions on how to do this.