I have a SQL written like this:
TheName = Bash'n'Crash
"SELECT * FROM Clients WHERE ClientName = '" + TheName + "'"
There are two apostrophies in the query and Access does not find the records.
If I only have one apostrophy in the word like in the following then it will work:
TheName = O'Brien
Changed TheName to read as O''Brien with two apostrophies between the O and Brien.
"SELECT * FROM Clients WHERE ClientName = '" + TheName + "'"
I have tried putting two apostrophies in the Bash''n''Crash name but it does not work.
Any help please?