How to delete records with a "?"

[doyle60]

How do I delete records from returning in a query that have a question
mark somewhere in a certain field?

I would normally write in the criteria row: Not "*?*"

But I guess the ? is a special character. I tried something like: Not
"*" & "?" & "*" but this did not work. How is it done, I've seen it
before but just can't get it? Thanks,

Matt

 

[Douglas J. Steele]

Try

Not "*[?]*"

 

[doyle60]

Thanks.

Matt