![]() |
vb sql query help
Hi,
I'm having some trouble with this line of SQL... Code:
"SELECT Ename, Enumber, Ecolour FROM TestTBL1 WHERE Tick = False and Region = " & myStringWhat I want the query to do is find the name(Ename), number(number) and colour(Ecolour) and if the happy tick box (tick) is unchecked and there region matches the user input (stored in myString) return the query. No errors seem to be poping up, but the code worked fine and returned some info before I added the "Tick = False". Can someone help me sort the statement out? |
Re: vb sql query help
What is the type of the field Tick in your access database.
|
| All times are GMT +5.5. The time now is 10:17. |