Microsoft Acces "yes/no"

  • Thread starter Thread starter Guest
  • Start date Start date
How do you query for "yes' in a "yes/no" data field?
Click to expand...

Yes/No fields are stored as numbers: -1 for Yes, 0 for No. You can use
a criterion of Yes (with no quotes), True, or -1; they'll all work.

John W. Vinson [MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro required for moving data between tables in specified format 10
Access how do you set a yes/no data type as required? 0
Is it possible to import/link messages frm Otlk express in MS acce 1
Prefilled Outlook Yes Voting Button response 0
Count of Yes with repeating fields 3
Access Table Yes / No Field Question 4
yes/no for old data 4
Yes/No field in Query 1

Back
Top