SQL Syntax Error

[DS]

I keep getting a Syntax Error on this code, any help appreciated.
Thanks
DS

MONEYSQL = "INSERT INTO SalesDetailsMoney " & _
"SalesDetailsMoney.SalesID, SalesDetailsMoney.LineID, " & _
"SalesDetailsMoney.ItemID, SalesDetailsMoney.QtyPrice,
SalesDetailsMoney.GroupID, " & _
"SELECT SalesDetails.SalesID, SalesDetails.LineID, SalesDetails.ItemID,
" & _
"SalesDetails.Quantity, SalesDetails.GroupID " & _
"FROM SalesDetails " & _
"WHERE SalesDetails.SalesID = Forms!MoveItem!TxtLeftID;"
DoCmd.RunSQL (MONEYSQL)

 

[Ken Snell \(MVP\)]

Yep.... that will give an error. You need to put the field list inside
parentheses:

MONEYSQL = "INSERT INTO SalesDetailsMoney " & _
"(SalesID, LineID, ItemID, QtyPrice, GroupID) " & _
"SELECT SalesDetails.SalesID, SalesDetails.LineID, SalesDetails.ItemID,
" & _
"SalesDetails.Quantity, SalesDetails.GroupID " & _
"FROM SalesDetails " & _
"WHERE SalesDetails.SalesID = Forms!MoveItem!TxtLeftID;"

 

[Duane Hookom]

You have an extra comma prior to "SELECT".

 

[DS]

Yep.... that will give an error. You need to put the field list inside
parentheses:

MONEYSQL = "INSERT INTO SalesDetailsMoney " & _
"(SalesID, LineID, ItemID, QtyPrice, GroupID) " & _
"SELECT SalesDetails.SalesID, SalesDetails.LineID, SalesDetails.ItemID,
" & _
"SalesDetails.Quantity, SalesDetails.GroupID " & _
"FROM SalesDetails " & _
"WHERE SalesDetails.SalesID = Forms!MoveItem!TxtLeftID;"

Worked Great! Thanks Ken
DS