Custom filter
[COMPANY] = 1 AND
[EMPLOYEE] = 28 OR
[COMPANY] = 1 AND
[EMPLOYEE] = 82
...trying to select multiple records to output to a file?
Solved! Go to Solution.
Hi vjconaway. Are you trying to use multiple criteria in a filter tool and need help with making it work? From your example, you would need to insert parenthesis around competing criteria, like:
( [COMPANY] = 1 AND [EMPLOYEE] = 28 )
OR
( [COMPANY] = 1 AND [EMPLOYEE] = 82 )
In your example, you could also write:
[COMPANY] = 1 AND [EMPLOYEE] In (28, 82)
Hope this helps.
Hello @vern,
You might also consider setting up a lookup table with a join tool to find the values:
Regards