Yes/ No

[AustinL]

I have a set of data with a yes and no checkbox. I want to run a report or query or something that will only show the boxes that are not checked. To elaborate I have client's and their bills. The checkbox is for "Billed" so once a client has been billed they are checked off. I want to run something that will show me only the entries that are not check (that haven't been billed)

 

[Norie]

Well why not just create a query with No as the criteria for the Billed field?

That could then be used as the record source of a report.

 

[AustinL]

I do not think that is an option. I have a checkbox. So when the client is billed I check the box and I want a report will only show unchecked boxes. So if there is a way to do that it would be great but I can't find one.

 

[Norie]

Is this field a Yes/No?

If it is then the underlying data is Yes/No, even if you are displaying a checkbox.

Did you try the query?

 

[AustinL]

Yes that works I just made the query = NO. Thanks for the help