Help with a query

[John Dumay]

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

 

[Rob Parker]

Hi John,

As you have found, the NOT criterion will exclude null values. Include IS
Null as another criteria (in the next "Or" row in the query design grid) if
you want to include records where the string is null; this will not prevent
records with another string from appearing.

HTH,

Rob