DoCmd.RunSQL where SQL has "/" in the string

[jaaret]

I've written a Delete Query that deletes records from a linked table named Neighbor where the string field DocDate has zeroes for days, such as "05/00/1999"
The Delete Query works but when I try to use the SQL code in a RunSQL statement (below) the forward slash characters cause an error. What is the work around for this?

'Delete records from the linked Neighbor table with
'days denoted with zeroes
DoCmd.RunSQL "DELETE NEIGHBOR.DOCDATE FROM NEIGHBOR _
WHERE (((NEIGHBOR.DOCDATE) Like "*/00/*"));"

Thanks!
Darrell

 

[lespaul]

I think if you use single ticks in the LIKE that it will work:

DoCmd.RunSQL "DELETE NEIGHBOR.DOCDATE FROM NEIGHBOR _
WHERE (((NEIGHBOR.DOCDATE) Like '*/00/*'));"

Leslie

 

[RoyVidar]

I would think the double quotes withing the string would cause the first problems, could you try using single quotes, just:

DoCmd.RunSQL "DELETE NEIGHBOR.DOCDATE FROM NEIGHBOR " & _
"WHERE (((NEIGHBOR.DOCDATE) Like '*/00/*'));"

Roy-Vidar

 

[RoyVidar]

Ah - again, lespaul;-)

Roy-Vidar

 

[lespaul]

one of these days, you might get in first!!!



Leslie

 

[jaaret]

I'm amazed at the speediness! Thank you both!

Darrell in beautiful, hazy Seattle