Delete query Not In Like xxxxxx*

[Michael Abrams]

I have tried various variations, but I can't get it correctly.

I have field PENCIL_NUM WITH 100'S of different numbers. What makes them unique is that they are grouped by the first 6 digits.

The query i am attempting to create, I want to exclude 3 different groups.

So I tried different variations of Not In (Like 555555*)

I was unable to find a function that says "Does not begin with".

Can you please assist?

Thank you
Michael

[HansV]

Try

Not Like "555555*"

[Michael Abrams]

Thank you Hans. I do need three groupings.

Not Like "555555*"and Not Like "666666*" and Not Like "7777777*" did not work.

Not Like ("555555*","666666*","777777*") did not work.

Michael

[HansV]

You have seven 7s in the last one. The following should work:

Not Like "555555*" And Not Like "666666*" And Not Like "777777*"

S1730.png

Left: before, right: after.

[Michael Abrams]

Thank you Hans.

Works great as desired.

Much appreciated !