You can try the following, I will prefix the variables so you'll understand the data type which are implied...
dim s as string
s = "SELECT * FROM " & strTable & " WHERE FieldString1 = '" & strVar1 & "' AND FieldString2 = '" & strVar2 & "' AND FieldNum1 = " & intVar1 & " AND FieldNum2 < " & intVar2
'Notice that string types need to be surrounded by single quotes and numbers do not.