|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 15th, 2004, 03:13 AM
|
|||
|
|||
Writing Criteria Expression
When creating a simple query, how do I write a criteria expression that will
retreive only records with a "Yes" value in a field with "Yes/No" data type? 
|
|
#2
October 15th, 2004, 03:24 AM
|
|||
|
|||
|
= True
-- Ken Snell MS ACCESS MVP "amyfinlay" wrote in message ... When creating a simple query, how do I write a criteria expression that will retreive only records with a "Yes" value in a field with "Yes/No" data type?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data type mismatch in criteria expression | Paul James | Running & Setting Up Queries | 5 | September 8th, 2004 01:13 AM |
| need help with a relatively simple criteria expression | Paul James | Running & Setting Up Queries | 9 | August 17th, 2004 11:24 PM |
| data type mismatch in criteria expression when no criteria specified | JR | Running & Setting Up Queries | 1 | July 27th, 2004 03:47 AM |
Linear Mode
