[CaptainEstock]

Hello all

I have a table called PRODUCT and the unique field in the table is called PARTNUMBER like so:

PARTNUMBER DESCRIPTION
12345(6) Widget 1
12347(5) Widget 2

my select SQL looks like this
SELECT * FROM PRODUCT WHERE PARTNUMBER = '12345(6)'

That statement fails. what can I do to get around this error?

Regards
The Captain

[That Guy]

The only obvious thing I can think of is that you should use the double quotes and not the single quotes.

This works in SQL View in Access:

SELECT PRODUCT.*, PRODUCT.PARTNUMBER
FROM PRODUCT
WHERE (((PRODUCT.PARTNUMBER)="12345(6)"));

[Pat Phelan]

How does the statement fail? Does it produce an error message?

-PatP