microsoft access 2000-design view-find certain records - records have periods and 1 quotation mark

davetough
davetough used Ask the Experts™
on
Helllo,
I want to create queries based on a table in access 2000.
I am wondering is there a way to query when record has quotation mark and comma. Normally one of the names I am querying is 3 day air- but now in many of records it is spelled
n.3 day air"    -  so normally In design view- I write in criteria under field 3 day air- but now when I try - my query is empty- is there a way to query these mis-spelled records without normalizing the data? - (all the mis-spelled records have a n. and a comma at the end.)
thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try
'n.3 day air"'
or
Like "*3 day air*"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial