Convert check boxes in a table to text boxes on a report

[ckpoll2]

Ok, so I'm wondering if what I need to do is even possible because I haven't been able to figure out how to do it and I haven't seen any similar posts on here.

In a table, I have a series of fields with course names as the title (SAA-OC, SAA-TA, etc.) There are also fields with employees names and other information. Each record is a unique employee and, under the course name fields, there are a series of check boxes that show which courses each employee has taken.

I'm trying to produce a report that will show names of employees and which courses they've taken. I don't want to show the text boxes on the report; I'd rather have the name of the course appear if it's checked for the employee and not appear if it's not checked. This list of courses will appear for each employee, which are sorted by last name. Is this even possible? Please let me know if my description is insufficient.

Chuck

[FishVal]

Hello, Chuck.

Database Normalization and Table Structures.
Keeping database normalized, you would never have issues like you are having now.

Kind regards,
Fish.

[ckpoll2]

Thanks, Fish. Actually, I didn't design this database. Unfortunately, someone else put it together and I'm just stuck with trying to make sense of it all. Do you know if my need is possible and, if so, how I can go about it?

Chuck

[FishVal]

Well.

There could be several workarounds.

• You may "normalize" your dataset dynamically:
  • Content of each "course" field is being retrieved to a separate dataset together with table PK. Simultaneously content is filtered by True and replaced with course name.
    

    SELECT tbl.PK, '...course name ...' as txtCourseName FROM tbl WHERE [course name];
     

  • Thus obtained datasets are UNION'ed into a normal form giving existing combinations employee/course.
• You may merge courses names into CRLF separated list and use it as ControlSource of textbox which CanGrow property is set to True.

[ADezii]

@ckpoll2
ckpoll2, how about posting some sample data (Field Names and Values), and also the results that you would like to see. This will give us, or at least me, a much better idea on how to proceed.