Query Question for the newbie

  • Thread starter Thread starter CB
  • Start date Start date
C

CB

I just need to query a table where no data exists in one
field or I as refer to as empty/blank.

I have tried various expressions only to get data which is
what I don't want. I just want the blanks.

Any suggestions I would greatly appreciate.

Thanks
 
-----Original Message-----
I just need to query a table where no data exists in one
field or I as refer to as empty/blank.

I have tried various expressions only to get data which is
what I don't want. I just want the blanks.

Any suggestions I would greatly appreciate.

Thanks





.
Click to expand...


Type "Is Null" as the critera in the field.


Damien
 
I just need to query a table where no data exists in one
field or I as refer to as empty/blank.

I have tried various expressions only to get data which is
what I don't want. I just want the blanks.

Any suggestions I would greatly appreciate.

Thanks
Click to expand...

Where YourTable.YourField Is Null
 
Thanks much. I guess I did not realize it needed to be
caps.
Click to expand...
What caps.
Access is case insensitive.
Is Null, is null, iS nUll are all the same to Access.
As a matter of fact, no matter how you enter those words, Access will
re-write them as Is Null.
Perhaps you didn't have the space between the words and wrote isnull.
There is an IsNull function, i.e. IsNull([FieldName]),
but
[FieldName] Is Null
is what you need here.
 
Thanks much. I guess I did not realize it needed to be
caps.
Click to expand...

ummm... it doesn't.

The criteria is null, Is Null, and IS NULL will all work. (The query
designer may convert them all to Is Null but you can type them in
capitalized however you like).
 
Back
Top