Recent content by hwkyetkd11

I believe I figured it out, thanks for the help. Knew access two years ago but havent looked it since so been lots of fun

after I connect the fields how do I get them into a table? The format for each of the 7 tables now is date, time, and sample 1. I want to link them by date and time showing all the sample 1 fields on one table. I just linked them by date and time so I have a bunch of black lines running all...

Sorry guys I havent used access a whole lot and just got thrown into this project. With myc urrent SQL I get all the headers I need for my table, how do I link the data and make a table with all the needed information. There may eb an easier way of doing this, I am all ears!

They all have teh same date and time stamp that should connect them. The sample 1 value is different for each currently existing table. Sample 1 is the data it reads in.

Okay here is my SQL SELECT [A - Top Hng S Thickness 1 ---- QC].Date, [A - Top Hng S Thickness 1 ---- QC].Time, [A - Top Hng S Thickness 1 ---- QC].[Sample 1], [B - Btm Hng S Thickness 1 ---- QC].[Sample 1], [C - Top Width 1 ---- QC].[Sample 1], [D - Btm Width 1 ---- QC].[Sample 1], [E - Btm Hdl...

I currently have 7 tables and want to consolidate some of the information from them into one. I have been trying to construct a table through a Query but it says I have entered an expression that has an invalid reference tot he property and then will not set up the look up wizard. Cana ny one...