Is null / not null statements

[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

[JKing]

Hi you would include this in the WHERE statement of the query.

SELECT field1, field2, field3
FROM table1
WHERE table1.field1 IS NOT NULL
 

Just replace IS NOT NULL with IS NULL for the opposite.

[mojo1979]

Hi you would include this in the WHERE statement of the query.

SELECT field1, field2, field3
FROM table1
WHERE table1.field1 IS NOT NULL
 

Just replace IS NOT NULL with IS NULL for the opposite.

Great thank you. Worked first time which has saved me trawling the net!

[JKing]

You're welcome!

JKing