How to Query a Table to find records showing checked boxes

[Needhlp]

How to Query a Table to find records showing checked boxes??

I have a table listing xxx reasons for dispute - Users will check boxes. How do I build my query that would list all the entry numbers which have a text box?

Might sound stupid but what would be the criteria? Think it would be easier to get these results into a report and sum.

I'm baffled!View attachment New database.10152007.mdb.zip

 

[Jon K]

Your database contains many tables and queries.

It will help if you can give us more details e.g. which table, which query and exactly what you meant by "list all the entry numbers which have a text box".
.

 

[Needhlp]

Reply from: 'How to Query a Table to find records showing checked boxes

I have a table listing xxx reasons for dispute - Users will check boxes. How do I build my query that would list all the entry numbers which have a text box?

Might sound stupid but what would be the criteria? Think it would be easier to get these results into a report and sum.

I'm baffled!View attachment 19142

The table is InvoiceData testja_aa

 

[Needhlp]

Your database contains many tables and queries.

It will help if you can give us more details e.g. which table, which query and exactly what you meant by "list all the entry numbers which have a text box".
.

I'm new to this forum. Don't know if this is the right place to answer but the table is InvoiceData testja_aa

 

[Needhlp]

Reply to a question about query:

Your database contains many tables and queries.

It will help if you can give us more details e.g. which table, which query and exactly what you meant by "list all the entry numbers which have a text box".
.

I wish to get the following result:  
All Entry Nbr showing a check in a boxe (YES) 
Ex.:
110-46577880-1     X               X           x
112-69608798-1              X             X
Result: How many Entry numbers were rejected for HST inelig, etc...
Thanks for your help!

 

[Jon K]

See the query in the database.

Hope it's what you are after.
.

 

[Needhlp]

How to Query a Table to find records showing checked boxes??

See the query in the database.

Hope it's what you are after.
.

Looking at it, I think so.  
However, when you specify multiple criterias, aren't you limited to a certain number of criterias? The table has 17 columns with a possibility of entering a check mark.  In such a case would a report do the job?  I don't think so.  What is your feedbac,

 

[Needhlp]

Can you keep adding "Yes" expressions below the OR cells to be able to look at all the columns where there is a possibility of a YES. There are more than seventeen "check box" columns.

 

[EMP]

When you have used up all the OR rows in query Design View, you can switch the query to SQL View and add the Yes for the remaining fields in the Where Clause, though I have no idea how many OR criteria we can use in a query. I have never used that many in a query.

^

 

[Needhlp]

I'll certainly try that! I have never had so many OR previously, that's why I was baffled.
Thanks to both of you Jon & EMP