"Does not contain" on a Text Field

  • Thread starter Thread starter Darrell
  • Start date Start date
D

Darrell

How do I filter a text field in a table so that my list "does not contain" a
key word? I am not sure how the expression should look and my attempts at
researching a solution have failed. Can I filter on a keyword or does it have
to be an exect match? i.e. I want to eliminate all records that contain the
word "Administrative"

[dbo_MSP_EpmTask]![TaskName] «Expr» Not "Administrative" ?

Darrell
 
If it's an exact match, use

[dbo_MSP_EpmTask]![TaskName] <> "Administrative"

If it's not an exact match, use

[dbo_MSP_EpmTask]![TaskName] NOT LIKE "*Administrative*"
 
Douglas,

Thx... I was using "%Administrative%" and getting nowhere!

Darrell

Douglas J. Steele said:
If it's an exact match, use

[dbo_MSP_EpmTask]![TaskName] <> "Administrative"

If it's not an exact match, use

[dbo_MSP_EpmTask]![TaskName] NOT LIKE "*Administrative*"


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Darrell said:
How do I filter a text field in a table so that my list "does not contain"
a
key word? I am not sure how the expression should look and my attempts at
researching a solution have failed. Can I filter on a keyword or does it
have
to be an exect match? i.e. I want to eliminate all records that contain
the
word "Administrative"

[dbo_MSP_EpmTask]![TaskName] «Expr» Not "Administrative" ?

Darrell
Click to expand...
Click to expand...
 
Working inside Access, the "*" wildcard means "any characters or none".

SQL-Server uses "%" to do the same.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Darrell said:
Douglas,

Thx... I was using "%Administrative%" and getting nowhere!

Darrell

Douglas J. Steele said:
If it's an exact match, use

[dbo_MSP_EpmTask]![TaskName] <> "Administrative"

If it's not an exact match, use

[dbo_MSP_EpmTask]![TaskName] NOT LIKE "*Administrative*"


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Darrell said:
How do I filter a text field in a table so that my list "does not
contain"
a
key word? I am not sure how the expression should look and my attempts
at
researching a solution have failed. Can I filter on a keyword or does
it
have
to be an exect match? i.e. I want to eliminate all records that contain
the
word "Administrative"

[dbo_MSP_EpmTask]![TaskName] «Expr» Not "Administrative" ?

Darrell
Click to expand...
Click to expand...
Click to expand...
 
Back
Top