Appending in an Update query

[adenjones]

I am trying to do something that seemed quite simple at first but that doesn't appear to be working. I am trying to append text in an update query.

DoCmd.RunSQL "UPDATE tblFileNotes SET fldActivitesUndertaken ='" & Me.fldClientFirstName & ", " & Me.fldClientLastName & ": " & fldActivitesUndertaken & "' WHERE fldClientID =" & Me.fldClientID

So I am grabbing fields from a form and then attempting to append them to the existing data in fldActivitesUndertaken.

Any help would be greatly appreciated.

Cheers

 

[adenjones]

I found the solution myself.

For anyone who is interested:

DoCmd.RunSQL "UPDATE tblFileNotes SET fldActivitesUndertaken = fldActivitesUndertaken & '" & Me.fldClientFirstName & ", " & Me.fldClientLastName & ": ' WHERE fldClientID = " & Me.fldClientID