Finding a blank field in records

[Roger]

I have created a table of data on vegetable seeds for 2008.
It contains the name, date of sowing and location of sowing, ect..
I want to create a query to only show those seed that have not yet been sown, i.e. location, a text field, is blank.
If I use query designer and the functions 'Blank' or 'NULL', as suggested in the help section of Base, I get a result of zero records, althought there are many seeds not sown at this time of the year.

If I try using the query wizard I am not offered the options of 'Is Blank' and 'Is Not Blank'. 'Is greater than', etc, are not much use in a text field!

What is going wrong here?

Thanks in anticipation.

Roger

[DrewJensen]

Don't ask me why - I don't know - but the Base developers chose
IS EMPTY

So open the Query Designer and add IS EMPTY in the criteria for the column.