Query for blank fields

[Thorpe]

I have table that has a field that can be empty or contain a string. I need
a query pull out on entries that have empty fields how can I do this

thanks

 

[Newbie]

Select * from table where fieldname is null or fieldname = ""

HTH

 

[John Spencer (MVP)]

Assuming that you are using the query grid, you would put "Is Null" (no quotes)
into the criteria under the relevant field.

Field: YourFieldName
Table: YourTableName
Criteria: Is Null