Query exclude number (1 Viewer)

Ports

Registered User.
Local time
Today, 04:23
Joined
Jun 30, 2019
Messages
64
Hi
I am trying to exclude value 40 in a query. Most records in this field are blank, some have numerical values. I would only like to exclude 40 from those values keeping all the blanks and other values.

When I do:
<>40
It also removes all the records with where this field is blank keeping only the records with a numerical value (excluding 40).

Please advise.

Thank you
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 04:23
Joined
Aug 30, 2003
Messages
36,118
Try

<>40 Or Is Null
 

Ports

Registered User.
Local time
Today, 04:23
Joined
Jun 30, 2019
Messages
64
Works fine. Thank you
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 04:23
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom