Insert Data from one table to another Query

[zipaway]

Hello, using VBA I would like to select entries in a table where a certain criteria is met.
Those selected entries would then be inserted into another table but not all of the columns, only a select few.

I have created the following code below but it is giving me an error when it runs the SQL (Syntax Error (missing operator) in query expression 'Sched_Delivery_DateFROM ShipDeliveryDates Where Project_Number =100'.

Dim pnumber As Integer
Dim cnumber As Integer
cnumber = DMax("Change_Number", "Change_Orders") + 1
pnumber = Text198.Value

Dim SQL2 As String



SQL2 = "INSERT INTO Change_Orders_Dates ([Change_Number], [Project Number], [ShipmentNumber], [Current_Sched_Delivery_Date], [Current_Sched_Ship_Date])" & _
"SELECT " & cnumber & ", " & pnumber & ", ShipmentNumber, Sched_Ship_Date, Sched_Delivery_Date" & _
"FROM ShipDeliveryDates WHERE Project_Number =" & pnumber & ""

DoCmd.RunSQL SQL2


Tables

ShipDeliveryDates	Change_Orders_Dates	Change_Orders
Project_Number	Change_Number	Change_Number
ShipmentNumber	Project_Number	Project_Number
Sched_Ship_Date	ShipmentNumber
Sched_Delivery_Date	Current_Sched_Ship_Date
	Current_Sched_Delivery_Date
	New_Sched_Ship_Date
	New_Sched_Delivery_Date

Please let me know what I'm doing wrong, any help would greatly be appreciated.

[pbaldy]

Here's a very commonly used debugging technique:

http://www.baldyweb.com/ImmediateWindow.htm

For starters, watch out for spaces between lines.

[zipaway]

Here's a very commonly used debugging technique:

http://www.baldyweb.com/ImmediateWindow.htm

For starters, watch out for spaces between lines.

Thank you so much for the tip! I figured out I need an extra space at the end of the first two lines of SQL.

[pbaldy]

Happy to help!