Does not Contain function

  • Thread starter Thread starter Haji
  • Start date Start date
H

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
 
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
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
I just tried this in Access 2000 and it seemend to work:

Not Like "*shipping*"

Maybe that will work for you.
 
Back
Top