Report only checked fileds (1 Viewer)

moyi

Registered User.
Local time
Yesterday, 19:13
Joined
Oct 31, 2017
Messages
15
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!
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 19:13
Joined
Aug 30, 2003
Messages
36,118
Sounds like a normalization issue. What do the fields contain (why 23 of them)? This may explain the problem:

http://www.r937.com/Relational.html

Likely your 23 fields should be records in a related table, where the number of fields checked becomes that number of records.
 

Users who are viewing this thread

Top Bottom