Delete query Not In Like xxxxxx*

User avatar
Michael Abrams
4StarLounger
Posts: 573
Joined: 10 Feb 2010, 17:32

Delete query Not In Like xxxxxx*

Post by 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

User avatar
HansV
Administrator
Posts: 78229
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Delete query Not In Like xxxxxx*

Post by HansV »

Try

Not Like "555555*"
Best wishes,
Hans

User avatar
Michael Abrams
4StarLounger
Posts: 573
Joined: 10 Feb 2010, 17:32

Re: Delete query Not In Like xxxxxx*

Post by 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

User avatar
HansV
Administrator
Posts: 78229
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Delete query Not In Like xxxxxx*

Post by 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.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
Michael Abrams
4StarLounger
Posts: 573
Joined: 10 Feb 2010, 17:32

Re: Delete query Not In Like xxxxxx*

Post by Michael Abrams »

Thank you Hans.

Works great as desired.

Much appreciated !