I have a report I am trying to create in Access. It has two groups: a task group and a subtask group (tasks within the main tasks).
In the details portion of the report I have a list of all the activities that belong under the subtasks.
I need to add a list of employees who work in each subtask. I have inserted a listbox into the report in the subtask group. The employee ids are linked to the subtask ids. I only want the names listed per subtask order once. I don't want them to repeat with every individual activity.
The list box is picking up the id information from the first subtask order in the report, but not reinheriting the next id information. So, throughout the report it just lists the employee information for the first subtask order repeatedly.
I don't know what is going on. Is it because it is in a header section, what with it being a group? If this is the case, can anyone tell me how to make this work?