I have multiple fields in a table that are set up as Yes/No and display as checkboxes on a form. Now I need to create a text field on a report that showes all the Yes answers. The text field needs to figure out if it's a Yes answer, then display the field name, if there is more than one yes answer in the fields it is looking at, it should separate each with a "," . This is a large text field, that could show as many as 10 Yes answers.
What is the best way to go about doing this? I use Access 2010
What is the best way to go about doing this? I use Access 2010
