Is Null / Not Null

[mojo1979]

Hi,

I am trying to create a query whereby it will only show only those records when the x field is null. I also need a separate query to do the opposite, i.e. to show only those records which have x field not null.

How can I do this?

I know I need a statement on the x field but don't know what it is?

Thanks in advance!

Steven

 

[pbaldy]

http://www.utteraccess.com/forums/showflat.php?Board=82&Number=1463295

 

[ajetrumpet]

Mojo,

SELECT()
FROM()
WHERE [field], [field] Is (Not) Null

This is very basic, I would advise you read the Access menu about functions in general....