Hi All,

I am sure there is a simple solution to this but my brain doesn't seem to be
working at the moment.

In my dataset one field has the value "Data Quaternity" and the other values
are NULL (but could be another string) and I want to exclude any records from
the dataset which have this value. I have tried to put the following
expressions in the Criteria for the query.

NOT "Data Quaternity"

or NOT Like "Data Quaternity"

But when I do this all I get is an empty data set.

I can sort on IS NULL in the criteria now, but I don't want to do this as
there will definitely be other strings in this field in the future.

Any assistance is of course appreciated.

Regards,

John Dumay