Hi all
I know this is a syntax issue, but I am struggling to get this statement correct. I have been working on it for hours and am hoping that someone can show me where I am going wrong.
Table xServices contains Long Text field [Onsite Contact] yes, I know about spaces and field names.Code:strSQL = "UPDATE [xServices] SET [Onsite Contact] = [Onsite Contact] & ExtNewOnsiteContact WHERE xServices.[MachineNo] = '" & MachineID & "'"
I want to concatenate [Onsite Contact] & ExtNewOnsiteContact and replace the existing value of [Onsite Contact] where the value of x.Services.[MachineNo] is equal to MachineID.
MachineID = [Forms]![Training & Services]![Machine No]
When I Debug.Print strSQL I get this
UPDATE [xServices] SET [Onsite Contact] = [Onsite Contact] & ExtNewOnsiteContact WHERE xServices.[MachineNo] = '1215-1490'
but frankly, I'm not sure what I am expected to see.
In this case MachineID is 1215-1490, so I know that part is correct, so it's probably the concatenation that is wrong.
Thank you in advance.