urgent: criteria expression for a blank field?

  • Thread starter Thread starter BunBun
  • Start date Start date
B

BunBun

i m looking for criteria expression for a blank field
i try many variations,eg =" ", "null"

can anyone help?

thx
 
If Nz([YourField],"") = "" Then ...

NOTE: there is NO space between the double quotes in the above expression.
A zero-length string ("") is NOT the same as a space (" "), nor the same as
a Null.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Fields in NOT Null Query Criteria 5
Use In() Expression as Query criteria with guts from Function 1
How to retrieve dates that meets a criteria using Query? Exp Build 1
Help with expression builder in a Query to retrieve wanted dates 2
Help with expression builder in a select Query 2
Criteria for select query. 2
#error - Blank 3
Filter out values of £0.00 in a query 3

Back
Top