Building Summary Report for List User Field
Hi! I recently added a List User field ("Estimator(s)") to my table where the person adding a new Project record can indicate one or more individuals involved in quoting a project. I would like to cr...
Forum Discussion
Unfortunately since the data you're reporting on is a list-user field you're going to have to report on this in another way. My best recommendation if you're able to swing it - is to try and report via some kind of 'Employees' table where you have a dataset of the actual team members. In that table, there are lots of ways you could do it but the easiest might be a formula query that counts the number of records where the user in question is listed in the list-user field and then you can build your report from that value in the Employees table.
------------------------------
Chayce Duncan
------------------------------
Thank you, Chayce. That is an interesting solution. I can create an employees table. How would I create the link between that table and the User-List field? I know how to create a table relationship, if needed. Would the "Estimators" field need to feed off the employee table, rather than my User list, or would I need to make the connection between the Estimators Field and the Employee table in my report?
------------------------------
Sherri Large
------------------------------