Does not Contain function

[Haji]

Hello,

I am trying to write a query against a transaction file
and want to exclude the word shipping. There are several
types of shipping and rather than doing a <> ten times for
each one, I am wondering if there was some kind of "Does
not contain" shipping.

Any help?

Haji

 

[Tom Ellison]

Dear Haji:

You could put the list of ten types of shipping in like this:

("Shipping1", "Shipping2", "Shipping3", . . . , "Shipping10")

Then use:
NOT IN ("Shipping1", "Shipping2", "Shipping3", . . . ,
"Shipping10")

Hello,

I am trying to write a query against a transaction file
and want to exclude the word shipping. There are several
types of shipping and rather than doing a <> ten times for
each one, I am wondering if there was some kind of "Does
not contain" shipping.

Any help?

Haji

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Guido]

I just tried this in Access 2000 and it seemend to work:

Not Like "*shipping*"

Maybe that will work for you.