Finding records with a "/" character in a field

[rlh]

Sorry if this is a dumb question, but I was given this database to
fix and I'm not well versed with Access.

There's a query in which a text field has a criteria of
Like "*['/']*"

It's suppose to only pick up records where there is a "/" character.
However it seems to be picking up records with "'" character.

Am I correct that the the criteria should be
Like "*[/]*"

and that the "[]" means match any character specified within the brackets???

TIA

 

[MGFoster]

Sorry if this is a dumb question, but I was given this database to
fix and I'm not well versed with Access.

There's a query in which a text field has a criteria of
Like "*['/']*"

It's suppose to only pick up records where there is a "/" character.
However it seems to be picking up records with "'" character.

Am I correct that the the criteria should be
Like "*[/]*"

and that the "[]" means match any character specified within the
brackets???

You are correct.

 

[rlh]

'MGFoster' wrote on 3/13/2009 4:32 PM:

Sorry if this is a dumb question, but I was given this database to
fix and I'm not well versed with Access.

There's a query in which a text field has a criteria of
Like "*['/']*"

It's suppose to only pick up records where there is a "/" character.
However it seems to be picking up records with "'" character.

Am I correct that the the criteria should be
Like "*[/]*"

and that the "[]" means match any character specified within the
brackets???

You are correct.

Thank you so much!

 

[fredg]

Sorry if this is a dumb question, but I was given this database to
fix and I'm not well versed with Access.

There's a query in which a text field has a criteria of
Like "*['/']*"

It's suppose to only pick up records where there is a "/" character.
However it seems to be picking up records with "'" character.

Am I correct that the the criteria should be
Like "*[/]*"

and that the "[]" means match any character specified within the brackets???

TIA

If the field value is like "Just/Find"

This works for me:
Like "*/*"
as does
Like "*[/]*"
as does
Like "*" & "/" & "*"