locationsetc
Programmer
Hello friends,
I have a little doubt on sql query. Iam using MS Access table. In table, I have a field called 'franchise' with datatype Yes/No(check box). i want to retrive records where franchise equal to true(or yes). how do we write the query for that? i have tried several ways but it did not work. here are some i tried:
SELECT * FROM EMAILcontacts WHERE franchise=1
SELECT * FROM EMAILcontacts WHERE franchise=True
SELECT * FROM EMAILcontacts WHERE franchise=Yes
the error is :
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
with regards,
Joseph.
I have a little doubt on sql query. Iam using MS Access table. In table, I have a field called 'franchise' with datatype Yes/No(check box). i want to retrive records where franchise equal to true(or yes). how do we write the query for that? i have tried several ways but it did not work. here are some i tried:
SELECT * FROM EMAILcontacts WHERE franchise=1
SELECT * FROM EMAILcontacts WHERE franchise=True
SELECT * FROM EMAILcontacts WHERE franchise=Yes
the error is :
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
with regards,
Joseph.