Query Criteria ==> Is Null versus ""

[R_J_Potter@msn.com]

MS Office 2010

I have a query that checks for missing data (Blank Field)

What is the best criteria to use if I want to test if [FIELD5] = Blank

I've used both Is Null or "" as criteria. It does not always give me the correct results...

Example:
Field1 Field 2 Field 3 Field 4 Field 5
Value Value Value Value Value

Data:
Sales Tax - - - - - - - - - - - - Texas
Sales Tax - - - - - - - - - - - - Blank <==I want to see this Record

Criteria:
"Sales Tax" Is Null

This data is imported from a Non-Office Program...

 

[boblarson]

Create a separate field in the query

Expr1:Len([Field5] & "") = 0

Then in the criteria use

True