Synax error

[ifeyinwa]

hey guys I am getting an error at the 'AUDIT' what am I doing wrong. billno is alpanumeric


SQLQuery = "SELECT * FROM tblopgaCOm2 WHERE billNo = '"&billNo&"'" and area like 'AUDIT'

 

[FesterSXS]

your quotes are in the wrong place. try this instead:

SQLQuery = "SELECT * FROM tblopgaCOm2 WHERE billNo = '"&billNo&"' and area like 'AUDIT'"

Also, instead of using *, just list the fieldnames that you actually require in your recordset - it would be much more efficient this way.

SELECT fieldname1, fieldname2, fieldname 3 FROM tblopgaCOm2......

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[steven290]

al so you might want to try

.. area like '%AUDIT%'"

not sure how you are looking for it

 

[ifeyinwa]

thanks guys