Access criteria

[sunnywink]

Hi all,

I have an Access query. I would to show all records except records where the Field, Partner, contains the word "cancel".

The criteria which I entered in the criteria field is: Not Like "*cancel*". However when I used this criteria to query, those records with the Partner field empty also did not show up.

Does anyone have idea how can I filter out all records, both empty and with values, except those records with the word "cancel" in the Field Partner?

Thanks in advance.

 

[Nikita6003]

Hi sunnywink

try adding OR Is Null to your criteria

(i.e. Not Like '*cancel*' or Is Null )

Hope this helps

Cheers
Nikki

 

[sunnywink]

thanks a lot, it's a great help!