searching for quotes

[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!

 

[Brian Camire]

You might use a criteria like

Like "*""*"

on these fields.

 

[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.