I am trying to create a string variable that I will use as a SQL argument. See example below.
strsql = "SELECT abc FROM def WHERE abc=" & user_input
The user input needs to be enclosed in apostrophes for the SQL statement to work, as abc is a Text value. So, the result I want is that strsql = SELECT abc FROM def WHERE abc="USER SELECTION"
How can I get apostrophes around the USER SELECTION, using a concatenation as shown above?
Thanks for any help that I can get on this!