Remove Duplicates From a List

[Reid]

I know this has been covered before but I can't get the other solutions to work specifically for what I want to do.

Job_Number Table Hours Logged Table

Job_No Field (related) Job_No Field

Number_of_hours

Employee Name

In table form here is what I get. (For Hours Logged Table)

Job_No Employee

1 Mike

1 Mike

1 Mike

1 Jason

1 Sandra

1 Sandra

I want a calculation that will = Jason, Mike, Sandra

How can I do this?

[comment]

Do you have an Employees table?

[Reid]

yes

[comment]

OK, so if you have the following relationships:

Jobs -< Hours >- Employees

you can get a list of employees that worked on a job by calculating (in the Jobs table) =

Substitute ( List ( Employees::Name ) ; ¶ ; ", " )