[RESOLVED] sql problem

i am trying to get some records from my database(ms access) using an sql command.
what is wrong with this?
adoPrimaryRS.Open "select field3 from 345_POLICY where field3 = " & usermotor & "", db, adOpenStatic, adLockOptimistic
when i run the program i get the error
syntax error(missing operator) in query expression 'field3 = 333'.
please help

If field3 is non-numeric then you will have to include apostrophes in your query like this

VB Code:

adoPrimaryRS.Open "select field3 from 345_POLICY where field3 = '" & usermotor & "'", db, adOpenStatic, adLockOptimistic

thanks a lot that work!

Quote:

---

Originally Posted by petros

thanks a lot that work!

---

You are welcome. PLease make sure you mark your thread resolved by opening thread tools at the top of this thread and select Mark Thread Resolved from the Menu.