Hello everyone, I have been stumped recently and am in need of help.
#Scenario
I have set up a system using Forms to add employee Discrepancies(errors @ work) to a table (eventually to be printed as a report each month). The fields that need to show on the report are; "Error Name", "Number of times conditioned", "Employees who were conditioned".
#Problem
So far I have the report printing almost like this using a query except I do not know how to show multiple employee names next to the same condition, for instance:
What I need:
Spilled Coffee::::::::4::::::::John, Mary, Ted
Right now it's showing:
Spilled Coffee:::::::2:::::::John
Spilled Coffee:::::::1:::::::Mary
Spilled Coffee:::::::1:::::::Ted
The employee name and condition are multi valued fields BUT they are entered in using a form one at a time through out a given day, I have set the 'Totals" in the query to:
(Group by:Condition.value)
(Count:Condition.Value)
(Group By:employeename.Value)
I will be active on here all day to get this resolved as it is important, I know this is vague and that most experienced members will have questions prior too please just ask I will respond quickly.