query how to get only the yes checked box

[nona87]

Greetings,

i am new to access, i have to submit a project please help me
i created a table (contains ID, Name, almost 20 yes/no checkboxs)
i need to create a query where i specify the ID and it returns the id, name and all the yes checkboxes

what i got is all the check-boxes yes and no

please advise me and kindly note that i dont now programming and how to write it in access

appreciate your help
many thanks

 

[sepefrio]

nona87, in the query, in the criteria line for each check-box column, type YES. This will cause only those records where the field is Yes (a checked box) to be displayed.

 

[Pat Hartman]

nona,
Your table is almost certainly defined incorrectly. It sounds like it should actually be two tables. The parent table with the ID and name and a child table with one row for each checkbox. Given that structure, you can write a query that selects only the true checkboxes. Given your current structure, your request is not clear enough to actually create a query. Do you mean that you want only records where ALL the checkboxes are true or where ANY one of the checkboxes is true?

 

[nona87]

nona87, in the query, in the criteria line for each check-box column, type YES. This will cause only those records where the field is Yes (a checked box) to be displayed.

I tried to do so, but it didn't work

 

[nona87]

nona,
Your table is almost certainly defined incorrectly. It sounds like it should actually be two tables. The parent table with the ID and name and a child table with one row for each checkbox. Given that structure, you can write a query that selects only the true checkboxes. Given your current structure, your request is not clear enough to actually create a query. Do you mean that you want only records where ALL the checkboxes are true or where ANY one of the checkboxes is true?

I appreciate your reply
I don't know how to make parent table and child, but if its goining to solve the issue i will learn how
I attached the DB i created its so small and i think so easy and clear if you kindly open the attach to see

I created the query also where i sepecify the id and i want to get only all the yes checked boxes but i am getting all the no and the yes as well

I really need help to submit the work and I appreciate if someone help me

 

[Pat Hartman]

I split the table into three tables. The first defines the user fields. The second defines the attributes you are trying to track. And the third assigns attributes to users. This would be the "true" state. Absence would be the false state. This schema allows you to manage any number of attributes without program changes. Each new attribute is just another row in the attribute table.

 

[nona87]

I split the table into three tables. The first defines the user fields. The second defines the attributes you are trying to track. And the third assigns attributes to users. This would be the "true" state. Absence would be the false state. This schema allows you to manage any number of attributes without program changes. Each new attribute is just another row in the attribute table.

Thank you very much it is so clear
Thanks for your help