Query parameter: looking for acutual "

[PaulA]

Hi--

How do I query a table to bring up all records with a single double-quote mark?

I am looking for all records with a value entered in inches, such as 12" for twelve inches.

What is the syntax to query for an actual double quotation mark? I tried"

Like "*"" & "*" --which didn't work as well as
Like "*" & """ --which didn't work either.

Thanks.

 

[Nouba]

try Like "*" & Chr$(34) & "*" in the criteria row.

 

[susanmgarrett]

hAD SAME PROBLEM - SOLUTION WORKED WONDERFULLY!

Thanks very much for posting this. I had the same problem and your solution worked perfectly.