SQL Insert Into Line Continuation

[reggiete]

Hello All,

I am needing help with the following SQL line continuation syntax. The issue is after Hire Date

DoCmd.RunSQL "INSERT INTO PeerEvaluation (MysteryShopperID,[MLO Name],[MLO EID],[Assigned Analyst],[MLO Phone Number],State,District,ASM,[Call Attempt Status],[Call Scenario],[Name Used],[Mystery Call HyperLink],[NMLS ID],[Zip Code],[DLO Start Date],City,[Testing Month]) VALUES (Forms![Mystery Shopper Information]!ID,Forms![Mystery Shopper Information]![MLO Name],Forms![Mystery Shopper Information]![MLO EID],Forms![Mystery Shopper Information]![Analyst Assigned],Forms![Mystery Shopper Information]![MLO Phone Number],Forms![Mystery Shopper Information]!State,Forms![Mystery Shopper Information]!District,Forms![Mystery Shopper Information]!ASM,Forms![Mystery Shopper Information]![Call Attempt Status],Forms![Mystery Shopper Information]![MSI Call Scenario],Forms![Mystery Shopper Information]![Name Used],Forms![Mystery Shopper Information]![Mystery Call Hyperlink],Forms![Mystery Shopper Information]![NMLS ID],Forms![Mystery Shopper Information]![Zip Code],Forms![Mystery Shopper Information]![Hire Date]" _
& "VALUES(Forms![Mystery Shopper Information]!City, Forms![Mystery Shopper Information]![Testing Month])"

 

[JHB]

If that should be the only issuer then remove the keyword Values + the ( and insert a comma after [Hire date]:

... Information]![Hire Date], " _
& "Forms![Mystery Shopper Information]!City, Forms![Mystery Shopper Information]![Testing Month])"

 

[reggiete]

thanks that worked!

 

[JHB]

You're welcome, good luck.