Search for the literal * (asterick)

[Guest]

I have a field that I would like to search for the literal *(asterick). It
would need to find the following:

Example: A-100* CA

Is there a way to search using the * before and after the criteria with the
criteria being "*"?

Thanks!!
Emmy

 

[Guest]

* is used by access to denote muliplication so you have a problem with using
it within text unless you place the data within " " to let the programme know
it's text. You can then search on it as you would anything else.

Try using Like "*"

Hope this helps

 

[Rick B]

This was just answered in the last week or so. Do a search and read that
post.

I think it was something like...

Like ^*

or

Like "*^"

Or Like "^"

 

[Douglas J. Steele]

LIKE "*[*]*"