ANY& SELECT& LEFT

[AndreaSangalli]

Hello,

I have 2 tbls :PAYROLL and LABOR.

I need to take only the 12 characters from  each recordin the  LABOR table .

The formula how it is it give me only the very firs record that mach the conditions 

LEFT(
   ANY(
     SELECT( LABOR [EMPLOYEE],
        And([EMPLOYEE] = [EMPLOYEE],
            CONTAINS([EMPLOYEE], [EMPLOYEE])))),12)

I put also [_THISROW] in both the AND conditions but isn't give me give me any result.

Thanks in advance

Do you have any tips?

[Marc_Dillon]

You'd need to add a new column to LABOR that pulls the first 12 chars from each employee, then select on that new column.