Using Is Null in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a very simple query with some field with a blank. My instructor would
like me to use the function Is Null thru query in the field identify these
null fields. It is a numeric field and every time I put the IsNull in front
of my field and run the query I receive all 0's or -1 for the blank field. I
would like to know if I am doing this right.
IsNull([Project2]) is how I was instructed to perform this task. Project2 is
the name of the field with some fields that have values and some with blank
information. I really do not know what I am doing wrong. Presumably I should
be receiving a True or False. Could someone please help me. Thanks
 
Well, I won't do your homework for you, but will try to give you some hints
at what the problem is. First, you may want to do a search in the VBA Help
files on IsNull. Second, the IsNull() function will always return a boolean
result and, in Access, boolean values are expressed as -1 = True and 0 =
False. Third, to get what you are looking for will require you to use the
Criteria section of your query.
 
Back
Top