Query Criteria Yes/No

[Bob V]

I want to sort on a query criteria only those Yes [Ticked Box]
Thanks for any Help..Bob

 

[John W. Vinson]

I want to sort on a query criteria only those Yes [Ticked Box]
Thanks for any Help..Bob

"Sort" means to "put a set of records into a particular order".

I guess you mean *search* rather than sort.

A Yes/No field is actually stored as a number, -1 meaning Yes and 0 meaning
No. You can use your choice of -1, Yes, True; or 0, No, False as criteria.

John W. Vinson [MVP]

 

[Bob V]

Thanks John

I want to sort on a query criteria only those Yes [Ticked Box]
Thanks for any Help..Bob

"Sort" means to "put a set of records into a particular order".

I guess you mean *search* rather than sort.

A Yes/No field is actually stored as a number, -1 meaning Yes and 0
meaning
No. You can use your choice of -1, Yes, True; or 0, No, False as criteria.

John W. Vinson [MVP]

 

[Long Live Aaron Kempf]

Warning!

John Vinson is a known troll; he does nothing but run around promoting MDB

I would reccomend finding a credible SQL Server developer / dba in order to
suit your needs.

I want to sort on a query criteria only those Yes [Ticked Box]
Thanks for any Help..Bob

"Sort" means to "put a set of records into a particular order".

I guess you mean *search* rather than sort.

A Yes/No field is actually stored as a number, -1 meaning Yes and 0
meaning
No. You can use your choice of -1, Yes, True; or 0, No, False as criteria.

John W. Vinson [MVP]

 

[John W. Vinson]

Warning!

John Vinson is a known troll; he does nothing but run around promoting MDB

<chuckle>

Guilty as charged.

I would reccomend finding a credible SQL Server developer / dba in order to
suit your needs.

If your needs require SQL/Server, absolutely.

John W. Vinson [MVP]