I am facing a problem. One of my SQL statemnts is some what like that given below
"SELECT TableName.* FROM TableName WHERE TableName.FieldName='" & rs!SchoolName & "'"
When the SchoolName contains an apostrophe, error is resulted. Some SchoolNames can not avoid apostrophe character (Like St...