Creating a Query that returns only fields with data?

[Regression]

I am currently working on a database that by design has a large list of yes/no check boxes.

I am trying to create a query that returns all the check boxes that are true in the table and none that are false.

The problem that I am having seems to be with the OR operator.

I can not seem to formulate the query correctly to get this information. Instead the True criteria setting makes records where any item equals false not appear in the query results.

I am sure there is a way to do this but I am at a loss any help would be greatly appreciated.

 

[ggreg]

I am not sure what you want but there are only two ways
in the design view to set them....
if in each critria box you keep them all on the same line
you will only get back what all has checks.....but
if you going left to right go down one box for each field
you will get back any that has at least one check.
does this help?

 

[Regression]

Ggreg,

Worked great thank you so much.

My error was that I set my first critera on the critera line and then all the fields after that I set the criteria on the or line.

Meaning I only moved down once and then went straight across for all the ORs.

Thank you very much for your help and prompt reply.

=)

 

[ggreg]

Glad to help out!