vba query problem

[mwork]

Here is my code:
strSQL = "Select * FROM tblBuildingSize WHERE (length = '" & length & "') AND " & "(width = '" & width & "') AND " & "(height = '" & height & "');"

The values of length, width, and height will be something like 11'2". I think the quote sign(") is causing a problem but I'm not sure. Thanks to anyone that can help.

[mwork]

I figured it out. I had to get rid of the (") and use chr$(34)


length = Replace(length, """", "")
width = Replace(width, """", "")
height = Replace(height, """", "")

strSQL = "Select * FROM tblBuildingsize WHERE (length = " & Chr$(34) & length & Chr$(34) & ") AND " & "(width = " & Chr$(34) & width & Chr$(34) & ") AND " & "(height = " & Chr$(34) & height & Chr$(34) & ");"