Access : Null / Blank rows select

[jagadeesh.rt]

Hi,


I have created by external data from excel, while one of the column values are showing blank.



Beginner to MS-Acces


How can i find the column having null or values in table.
Error : Type Conversion Failure (ImportError table)


Query :

SELECT * From empdetail
WHERE EmpId =IsNull ("")

From the above query, not getting the result

[JoeM]

Try this:

SELECT * From empdetail
WHERE (EmpId Is Null) Or (EmpID="")

[June7]

You want records where the field is Null or empty string?

Other variations:

SELECT * FROM empdetail WHERE EmpID & "" = "";

SELECT * FROM empdetail WHERE Nz(EmpID,"") = "";

[jagadeesh.rt]

Try this:

SELECT * From empdetail
WHERE (EmpId Is Null) Or (EmpID="")

Hi,

Worked with the above query, getting error like

Data type mismatch in criteria expression

Thank U

[June7]

Is EmpID a number type field? Then it can never have an empty string. Try just:

SELECT * FROM empdetail WHERE EmpID Is Null;