Query where criteria is blank cell (1 Viewer)

[MatthewJapp]

Hi there - can someone please help, I am new to access and trying to return a query where the cell is blank. in criteria in qry build i'm putting ="" but when running qry getting a data type mismatch error...pls help driving me mad!! )

 

[Galaxiom]

There are two blanks. The Null string which is "". It is only valid for text.
Then there is The Null.

In your query criteria use:
Is Null

 

[MatthewJapp]

thanks for your help, much appreciated!