Hello, I am trying to create a report and have it show the user if 3 differnt check boxes are shown as checked or yes. How do you do this and what is the expression needed to do this?

Thank you,

Groggx

What do you want displayed? If you want the checkboxes displayed, put the checkboxes on the report and bind them to the yes/no field.

I just want it to display the user names that have the 3 check boxes checked off to yes. Any help is greatly appreciated.

I just want it to display the user names that have the 3 check boxes checked off to yes. Any help is greatly appreciated.

Not completely sure about this still. Can you post a screenshot of what you currently have and what you want it to look like?

I just want it to display the user names that have the 3 check boxes checked off to yes. Any help is greatly appreciated.

Do you have a Form with a list of user information that allows you to select users by checking boxes, and want to create a report showing the users that have been selected? If so, then you can base the report on a query like this:


Select {The fields that you want to display}
From {The Table or Tables that they exist in}
Where {CheckBoxColumnName} = True;