I have been trying to complete what I thought would be a simple task. I have a team member that needs to filter out about 12 part numbers out of a field. I have tried a couple of different variations, they either don't bring back any information or only get the first 2 part numbers.
I have tried all of the following variations:
Not In (04465, 04945, 04946, 04947, 47230, 47550, 47714, 47715, 47721, 47731, 47831, 47822)
Not 04465 Or Not 04945 Or Not 04946 Or Not 04947 Or Not 47230 Or Not 47550 Or Not 47714 Or Not 47715 Or Not 47721 Or Not 47731 Or Not 47831 Or Not 47822
Not (04465 Or Not 04945 Or Not 04946 Or Not 04947 Or Not 47230 Or Not 47550 Or Not 47714 Or Not 47715 Or Not 47721 Or Not 47731 Or Not 47831 Or Not 47822)
Not Like ("04465" Or Not Like "04945" Or Not Like "04946" Or Not Like "04947" Or Not Like "47230" Or Not Like "47550" Or Not Like "47714" Or Not Like "47715" Or Not Like "47721" Or Not Like "47731" Or Not Like "47831" Or Not Like "47822")
Kevin Robertson
@Reply 3 years ago
I am assuming the Data Type is Short Text as some of the numbers have leading zeroes. Enclose the numbers in quotes.
Not In ("04465","04945","04946","04947","47230","47550","47714","47715","47721","47731","47831","47822")
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
