I am trying to return records in this scenario: Assume a company with 5 employees: A,B,C,D,and E. Each empoyee can run multiple machines. I can set up a parameter query that returns results if I know the 2 employees that ran the machine. If enough time has passed, I will not remember who all operated the machine. I know that employee A operated the machine all day, but he worked with 3 of the others for parts of that day. I am trying to write a query that will accept data for employee A and return records for a specific helper or all the helpers that match employee A for that day. Example, employee A worked 8 hrs and helper B worked for two hrs, C worked for 1 hour, and E worked for 5 hrs. In my actual scenario, there are 68 employees. The query would return results that look like this: A B A C A E
Thanks in advance, Dan
