Nope - Doesn't like empty either. It finds empty date fields with {}.
Thanks





>Does EMPTY() work?
>
>
>>I am testing the Filter Dialog found in the solution samples. How does one get it to set a filter condition where you want all records that do not have an entry in a certain text field? I have a small table and this is the simple query capability that I need if I could use it to find text fields with missing data.
>>
>>I tried setting the field to '' which it prohibits, "",space(0), and also [] to no avail.
>>
>>
>>Any suggestions would be appreciated
>>Thanks