Using Search Criteria Eg: "Like 2005)*"

P

Palto Fondberg

Hi

I want to use a "like" criteria in an Access query to search for 2005)
but Access doesn't seem to like the use of the bracket [for clarification,
the bracket is part of my search string].

Am I able to use "Like" and specify brackets in the search?


thanks
 
D

Douglas J. Steele

There should be no issue with parentheses.

Are you simply typing Like 2005) into the Criteria cell in the query
builder? Use Like "*2005)*"
 
P

Palto Fondberg

Thanks Doug

I could have sworn on my life I tried this earlier and it didn't work - I
must have been half asleep!


Douglas J. Steele said:
There should be no issue with parentheses.

Are you simply typing Like 2005) into the Criteria cell in the query
builder? Use Like "*2005)*"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Palto Fondberg said:
Hi

I want to use a "like" criteria in an Access query to search for 2005)
but Access doesn't seem to like the use of the bracket [for
clarification, the bracket is part of my search string].

Am I able to use "Like" and specify brackets in the search?


thanks
Click to expand...
Click to expand...
 
J

jwahlton

Tagging onto this question, if I need to do a search of any PO numbers that
"end" with 655, how would I do that? They will come back as 68071391655 etc,
and I need a list of everything that would end with 655. I've tried what you
wrote below but can't get it to work.

Thanks
Julia
 
R

Ron2006

There are a number of ways. Here is one:

In your query design mode define a field as


Searchpart: right([tablename]![nameofPONumberfield],3)

in criteria put 655

or if the query creates that as a text field then
in criteria put "655"

Ron
 
Top