Q:

Assigning a string to a variable in Access VBA that contains double quotations

Consider this simple coding in Access VBA:
Dim sql As String
sql = "SELECT * FROM 1 where [1.how] ="good""

Because of the double quote surrounding the word "good", I am getting this compile error:

"expected end of statement"

How can I avoid this problem? 

A:

double every double quotes inside the string: 
sql = "SELECT * FROM 1 where [1.how] =""good"""

