>>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
>
>I noticed Cetin gave an answer. Just curious if ISBLANK() would have worked.
empty(),isblank() etc might work with "advanced filter" option of that sample. However in regular one it doesn't look like you can enter an expression.
Cetin