Left Function??

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining formats (i.e. bold, underline) for fields in forms/report 1
Split Names into Two Fields 2
Create Table from other Tables 2
Query Help! 2
Adding Expressions or Criteria or Lookup to a table 3
Access left joins returns incorrect rows 3
Equivalent to the Least function in SQL (or min in Excel) 8
Query problem. 10

Top