In a table called "T_Plates" there is a field called "Checkout" and this a a "Yes/No" field with acheckbox.
Now I like to make a select query to select all the records with a checked (Yes) Checkbox.
How can I put this in a query?
Novice
Windows 7 32bit 
Access 2007
In a table called "T_Plates" there is a field called "Checkout" and this a a "Yes/No" field with acheckbox.
Now I like to make a select query to select all the records with a checked (Yes) Checkbox.
How can I put this in a query?
Access Developer
Windows XP Access 2003
Put True in the Criteria Row, under the Checkout column.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Posting Permissions
Reply With Quote