I have three possible titles, 'Leader', 'Co-ordinator' or 'Convenor' from which a user selects one, which is assigned to a string variable, say strTitle
I need to update a table so that a report description reflects the users choice.
I need: "strSQL = UPDATE tbl_Reports SET [Description] = "Group " + strTitle"
I have been trying any number of single and double quote combinations here but cannot get this to work.
Any help gratefully received.