Query includes Quotation mark

[Ger]

Hi All

I'm having a problem with some queries i'm running. It queries on Stock
Code and some of the stock codes contain ". e.g MJMII1.5". I dont want
to eliminate the quotation mark because this may effect the accuracy of
my query. Any help would be really appreciated.

Thanks

G

 

[bf1]

I assume that your query's where clause says something like :
WHERE [Stock Code] = "MJMII1.5"" (which will not work)

You could try using single quotes around the stock code like so:
WHERE [Stock Code] = 'MJMII1.5"'

....your double quote is still part of the criteria, but the whole Stock
Code string is in single quotes.

HTH
Beth F.