SQL Syntax Error

D

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)
 
K

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;"
 
D

DS

Ken said:
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;"
Click to expand...
Worked Great! Thanks Ken
DS
 
Top