Using Search Criteria Eg: "Like 2005)*"

[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

 

[Ron2006]

Start with 2005) like "2005)"

has 2005) anywhere like "*2005)*"

 

[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)*"

 

[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!

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!)

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

 

[Guest]

PUEDO OBTENER ; AYUDA EN MI IDIOMA??????GRACIASSSSSSSSSSSSSSSSSSS

 

[John W. Vinson]

PUEDO OBTENER ; AYUDA EN MI IDIOMA??????GRACIASSSSSSSSSSSSSSSSSSS

"Palto Fondberg" <[email protected]> escribió en el mensaje de
noticias:#[email protected]...

http://office.microsoft.com/es-es/default.aspx

 

[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

 

[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