A
AJ
I have this query and cannot get it to work. I know the syntax is wrong so
can someone please help me?
strSQL = "select * from TableA" & _
" where Field1 = " & ex_field1 & _
" and Field2 = " & "'" & ex_field2 & "'" & _
" and left(Field3,1) = " & "'" & Left(field3, 1) & "'"
All I am trying to do is compare the first character on the field3.
can someone please help me?
strSQL = "select * from TableA" & _
" where Field1 = " & ex_field1 & _
" and Field2 = " & "'" & ex_field2 & "'" & _
" and left(Field3,1) = " & "'" & Left(field3, 1) & "'"
All I am trying to do is compare the first character on the field3.