Query for blank fields

  • Thread starter Thread starter Thorpe
  • Start date Start date
T

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
 
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
 
Back
Top