Select Where Yes/No (1 Viewer)

[dlugirapfr]

Dear All,

I want to write code to select records where field yes/no will be selected on yes.
I wrote code like this

Set rs = Mydb.OpenRecordset("SELECT * from tblCalc WHERE ((tblCalc.taknie)=Yes)")

tblCalc.taknie - it is yes no field.

I allays has the Error 13 problem, I tried:
tblCalc.taknie=Yes
tblCalc.taknie=0
tblCalc.taknie="1"
tblCalc.taknie=-1

And still the same problem. I use MS Access 2003. Thanks for any replay.

 

[Mihail]

Try this:

Set rs = Mydb.OpenRecordset("SELECT * from tblCalc WHERE taknie= -1")

 

[DavidAtWork]

since Yes/No fields are treated as True/False try this:
Set rs = Mydb.OpenRecordset("SELECT * from tblCalc WHERE tblCalc.taknie= True")

David