Yes/No Data type

[Guest]

In my table I have a column called "Completed" which is defined by a yes/no
data type. I want to create a query to only populate those records that are
checked as being completed. With my current query layout, it is generating
all records although the criteria has a value of "Completed." Please help.
Thanks

 

[Guest]

"Completed" does not mean -1. In a YesNo field Yes, True, or On is equal to
-1. No, False, or Off is 0.

Try putting -1 in the criteria without quotation marks.

 

[Guest]

Perfect, it works. Thanks!!

"Completed" does not mean -1. In a YesNo field Yes, True, or On is equal to
-1. No, False, or Off is 0.

Try putting -1 in the criteria without quotation marks.