Hello all, I'm a new beginner of Access.
I have 23 checkbox. I need to create a report for each user. The report shows fields that the user had checked only.
I don't know how to make it.
I was told that a query may help, but I don't know how to filter the query either.
For example, if I set up the criteria as Yes for all the fields, then only those who selected 23 fields appears. If I set up Yes in "or", then all fields are displayed.
Is there anyway to do this? Many thanks!
I have 23 checkbox. I need to create a report for each user. The report shows fields that the user had checked only.
I don't know how to make it.
I was told that a query may help, but I don't know how to filter the query either.
For example, if I set up the criteria as Yes for all the fields, then only those who selected 23 fields appears. If I set up Yes in "or", then all fields are displayed.
Is there anyway to do this? Many thanks!