I have a database with customers names such as O'Neil. This presents a problem when I look them up after the initial entry. The look-up uses an auto fill so it reduces typing. The name comes up as it should (O'Neil) but when I execute the query button to take me to the customer page I get the following message: Syntax error (missing operator) in query expression '[ClientCompanyName]='O'Neil"
Now that I now the the problem exists my work around is to simply not use an apostrophe when I enter a new customer. The problem is when I print a letter or anything else obviously their name is wrong There must be a way to enter these names correctly i.e, O'Neil vs O Neil and have the query work as it does with all the other names.