Real Easy...Yes/No Boxes, want to return all Yes records

[hardhitter06]

Hi All,

Access 2003.

Very Simple...I have a query that has about 15 fields. One of the fields is a Yes/No Box...I want to create a search that returns all the records with a "Yes" selection for that particular field.

In my query, what would I write in my Criteria for that field? I tried "Yes" and "True" but that isn't right.

Please help.

Thank you.

 

[lumpia]

Try both without the quotes. Yes if it is a yes/no box. True if it is a check box.

 

[David Eagar]

Try 0 (false) or -1 (true)

 

[apr pillai]

If you have used True (is a constant for the value -1) without Quotes then it will return the output correctly.

If you are not sure use -1 for True in the Criteria Row.

 

[hardhitter06]

Thank you all for your quick responses.

This is a query linked to a table therefore it is a "Yes/No" Field.

I tried "Yes", "-1", "True" (all with and without quotes) and when I do that, i then go to table view in the query and it forces that field to be Yes or Checked for every record in my query.

I also tried No or false and then no records have this Yes/No field checked.

Again, in design view of the query, next to criteria under the Yes/No field is where I am inputting this.

I figured what you all thought would work but it is not...any ideas why??

 

[apr pillai]

Is this Yes/No field is one of the Fields you are using to link between the Table and the Query?

 

[hardhitter06]

In my table i have a field called "MinorityOwned" with Yes/No as a Data Type.

In my Query, I use all of the fields from my main table (only table used) including this field.

So basically, my Query is exactly like my Table but it is in Query format so I can play around with the criteria and set up a search.

Hope that is clearer..

 

[hardhitter06]

You know what guys, Yes works...for some reason I think my database was hanging up. I went to lunch so I closed it out, reopened it and tried Yes since I found your same answer on a website and it worked.

Sorry to waste your time...but thank you much for your help!