searching for quotes

  • Thread starter Thread starter shank
  • Start date Start date
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!
 
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.
 
Back
Top