Hello everyone,



I have a database for reporting on employee conditions, the database has a form to input data to a table and another form to print the data table reports.

On the report it looks like this for all three:

Condition::::::::::::::::::::Amount of Conditions::::::::::::::::::::::::::Conditioned Employee
(list of conditions)::::::::::[count sum)::::::::::::::::::::::::::::::::::[ConcatRelated(employees conditioned separated by coma))

I have the Query set so that when an employee in a certain dept creates a record it goes to that dept's report, however the ConcatRelated() is listing names from every report. I know there are ways to edit the ConcatRelated() string so that it can do this or even alternate methods of filtering this:

=ConcatRelated("[condname]","reports","[cond] = '" & [cond] & "'")

even if I have to filter by typing in the list of employees in that Dept anything helps here, this is the last major bug we have run into regarding this project.