What's the opposite of "is null"?

[Guest]

I'm trying to make a query that brings back all records that have a value
stored (whatever it may be) in a certain field... what do i need to do?

Yours hopefully,

Ben

 

[Ken Snell [MVP]]

Is Not Null

or this will work too:

Like "*"

 

[dd via AccessMonster.com]

IS NOT NULL should do the trick.

 

[Fred Boer]

Took me a second or two to figure out why that worked, but I like it! Too
much negativity in the world without all those "Is Not"s !

Fred

 

[Fred Boer]

Argh! And too much bad typing.. make that:

Too much negativity in the world *as it is* without all those "Is Not"s!

Fred "Fumbles" Boer

 

[John Vinson]

Argh! And too much bad typing.. make that:

Too much negativity in the world *as it is* without all those "Is Not"s!

Fred "Fumbles" Boer

Ok, try properly punctuating this valid and meaninful philosophical
observation:

that that is is that that is not is not that that is is not that that
is not that that is not is not that that is is not that it it is

John W. Vinson[MVP]

 

[Fred Boer]

Hmm.. Is this correct?

That that is, is. That that is not, is not that that is. Is not that that is
not that that is not? Is not that that is - is not that it? It is!

Fred

 

[John Vinson]

Hmm.. Is this correct?

That that is, is. That that is not, is not that that is. Is not that that is
not that that is not? Is not that that is - is not that it? It is!

Not unreasonable! My version goes:

That that is, is; that that is not, is not. That that is, is not that
that is not; that that is not, is not that that is - is not that it?
It is.


John W. Vinson[MVP]

 

[Ken Snell [MVP]]

< g >

 

[Fred Boer]

That was fun. I'm saving it to give to my students in the last week of
school! Thanks!

Fred

P.S. Have you read "Eats, Shoots and Leaves"? You might enjoy it!

 

[Guest]

How 'bout this:

That that is, is. That that is not, is not. That that is, is not that that
is not. That that is not, is not that that is. Is not that it? It is!