Parenthesis in query

Question

I am trying to do an update query where the criteria is the first item of a phone number, a parenthesis.  How do I enter the parenthesis in the Criteria row?  Thank you.  I am using Win 7, Access 2003

Answer 1

Ummm... Shift-9, just (?

Or maybe

LIKE "(*"

if you want to find all phone numbers that start with a left parenthesis?

Given that you're asking the question, I gather that this isn't giving you the desired result. What specifically do you have now, and what do you want to update it to?

Answer 2

Sorry, Faxylady, but this isn't making sense. A criterion on a field of

Left([Company], 1) OR Like "(*"

applied to the Company field will probably not return what you think it's returning! The first criterion will only be true if the [Company] field is equal to its own first character (that is, a one-letter field). I'm guessing that

LIKE "(*"

would give exactly the same results - those records where the field starts with a left parenthesis.

Could you post an example of what's in the field and what you're trying to accomplish with it?

Answer 3

Thank you for responding.  I thought I had tried this b4 and it did not work.  However, I tried it again and somehow it DID work.  What I entered in the Criteria row was Left([Company],1) Or Like "(*" and it produced the results I am looking for.  Thanks again.

Answer 4

Like "(*"