Multiple linked tables query

[cchampagne17]

Hello,
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.. Thank you!!

 

[RainLover]

I would create a new Blank table with the correct Data Types, then Append the records from all the 4 Linked tables.

Result is that you have one Table will all the Data.

Search Access Help for Append Query. You should find all the info you need there.