How would i solve a problem with a SELECT query that includes a where clause = to a surname where the surname is O'Dowd..My query is:
WHERE (SellerNo = '" & sellerNo & "')
ORDER BY tempAuct.LotNo
It throws up the error,
Incorrect syntax near 'DOWD'.
Unclosed quotation mark after the character string ') ORDER BY TempAUCT.LotNo'.
I know that it is the Apostrophe in the O'Dowd is causing the problem?