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