Not Like "X*" in query critera, if empty does not show record (1 Viewer)

B

bruceblack

Registered User.

Local time

Today, 04:57

Joined

Jun 30, 2017

Messages

119

• May 31, 2018

• #1

Hi folks. I have NO clue if this is a bug or not.

I have a query with in a column (short text) that has a few numbers and sometimes it has X.

I want to exclude the value X. So in the column criteria is put

Not Like "X*"

This does work, but if the field is empty, it also filters it out!
Why? I'm only saying to exclude X. Not Null :banghead:

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 11:57

Joined

May 7, 2009

Messages

19,239

• May 31, 2018

• #2

just a guess enclosed X inside sqr bracket:

Not like "*[X]*"

 

June7

AWF VIP

Local time

Yesterday, 19:57

Joined

Mar 9, 2014

Messages

5,470

• May 31, 2018

• #3

Not a bug. The Null records should be excluded if you have any filter criteria because Null cannot be compared to anything so the Null always fails to match and records are therefore excluded.

Tested arnelgp suggestion and doesn't work.

Try:

Not Like "X*" Or Is Null

 

Last edited: May 31, 2018

B

bruceblack

Registered User.

Local time

Today, 04:57

Joined

Jun 30, 2017

Messages

119

• May 31, 2018

• #4

Youre both life savers with those quick responses!

Thanks June it worked. Stupid i didnt see that. THANKS!