searching for quotes

S

shank

How can I search for fields that have a quote " in them? Chr(34)...
I'm having miserable syntax problems.
How do the pros search for these?
thanks!
 
M

mark grizzle

You can use a single quote to wrap the double quote
you're searching for, in this case Like '*"*'
You can also use like '*' & chr(34) & '*'
This will make it much easier to read.
 
Top