Code:
INSERT INTO tblTemp ([ATFLoc], [ItemNo], [ProjNum], [SerialNum], [CR], [PolChk], [DateTested], [Beam], [MRA], [Imp1], [Ph1], [ImpZ], [FreZ],[PhZ], [Imp2], [Ph2], [Imp3], [Ph3], [TPR], [FF], [ActTemp], [DailyCount], [Operator]) VALUES ('N','1',9999,CD9999R,'FALSE',#4/29/20#,TRUE,89.0,PASS,300.00,-10.00,3.000,75.00,1.00,100.00,25.00,200.00,-20.00,PASS,PASS,11.0,1,JD)
I got rid of the syntax error thanks to your eagle eyes and I also found the missing field. Thank you. In the table that this data is being inserted to has 23 fields. the 24th and 25th would have been the UnitID(autonumber) which I left out of the sql statement per Gicu in post#7 and the whole QR code for each record which I am no longer saving. The autonumber field is in the main table that i will be appending to.