<> or not "string" query

[dunnes]

hello,
im currently using a query which doesnt want to include a certain string ie Lead. the column that i do this criteria search on has many other strings and empty strings, so when i use the criteria not "Lead" or <> "Lead" the filter seems to work but also filters away the blank strings..... is there any other way to filter out the string lead which doesnt also filter out the blank entries????



Cheers
Mike

 

[Philem]

Try this:

Not Like "Lead" Or Is Null

HTH
P

 

[dunnes]

cheers philm,
used the following code (accidently double posted adn someone else came up with this!!)

"Is Null Or" and then my expression


Cheers
Mike