Retrieving all records where the "End" column is empty empty

Question

I am writing a query in Access, where I need to get all the records, where a certain column is empty, how can I do this?

This is what I think should be, but it does not work.

SELECT * FROM TABLE WHERE PARTICULARCOLUMN = '' 

Answer 1

This will handle both empty rows ('') and NULL values ​​in the column.

 SELECT * FROM TABLE WHERE Nz(PARTICULARFIELD,'') = '' 

Answer 2

Try ...

 WHERE PARTICULARFIELD Is Null 

An example from the Internet:

 SELECT [Table1].[CustomerID], [Table2].[CustomerID] FROM [Table1] LEFT JOIN [Table2] ON [Table1].[CustomerID] = [Table2].[CustomerID] WHERE ((([Table 2].[CustomerID]) Is Null)); 

See: http://www.fabalou.com/access/Queries/isnullquery.asp