Select Query that includes a column that uses a yes/no datatype

[badger8]

I have columns that use the yes/no datatype, so in the table it puts a check in those that are yes.

I would like to create a select statment that can gives me a query results of just those records that have a check within one of these columns.

But how?

 

[nickjar2]

I can't quite remember but try using, as the criteria, either True or Yes. Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[BoxHead]

Badger,

I'm using Access '97 and Yes/No fields have values of negative one or zero.

Yes = -1
No = 0

Setting the criteria to -1 returns the records where the checkbox is ticked for Yes.



HTH John

Use what you have,
Learn what you can,
Create what you need.

 

[BoxHead]

And....

after further investigation, True/False and Yes/No work as well. Just like Nick said. John

Use what you have,
Learn what you can,
Create what you need.