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.

BTW, are you using access 2000?

You should be able to use the last two of your queries. That works perfect. Also found something strange. Try with -1 for YES and 0 for NO. Normally 1 is used instead of YES and 0 for NO. But in 2000, this is how it works. Not sure if Mircosoft has changed that in 2000.

SELECT * FROM EMAILcontacts WHERE franchise=True
   or
SELECT * FROM EMAILcontacts WHERE franchise=Yes
    or
SELECT * FROM EMAILcontacts WHERE franchise=-1

Cheers!

_________________________
- Vijay G
Strive for Perfection

Thanks Vijay

joseph