how to select multiple records to output

[vern]

Custom filter

[COMPANY] = 1 AND

[EMPLOYEE] = 28 OR

[COMPANY] = 1 AND

[EMPLOYEE] = 82

...trying to select multiple records to output to a file?

[dhovey]

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.

[afv2688 · Accepted solution]

Hello @vern,

You might also consider setting up a lookup table with a join tool to find the values:

Regards