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