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

row height in a subform 1
Row height in a subform 0
Adding Expressions or Criteria or Lookup to a table 3
Create Table from other Tables 2
Count field 4
Shift several columns in table 4
Macro to Select text from a point given to a specific word 2
Access 2007 - SQL query assistance needed 2

Top