VBA Query Syntax

[Juan4412]

I am using Debug.Print to check my syntax and after all is said and done this is the output from the Print statement. I get an error of Invalid Syntax when I execute this - but what element is invalid?

INSERT INTO VBAInsert ( CAC, Description, SS, MQ, P, AD, CPC ) SELECT CAC, [ItemCode] & ' ' & [Description] AS FullDescription, RED As SS,0 As MQ,0 As P,4/10/2017 As AD,TEST As CPC FROM TempHold;

[aytee111]

Text fields have quotes around them (RED/TEST table field or a text?), dates have #'s around them - #4/1/2017#. I would stay away from Access reserved words - if TEST is a field name.

[Juan4412]

They are text values being input into fields. So I would need to encompass with "" - and good call about the dates!

[rpeare]

You can encompass text values in either " marks or ' marks. Either one works, just make sure there's no chance of your data entry including a ' mark if you use ' encapsulation.