D
dennis g
Guest
Have a query to allow users to search by customer name. The query is: Like "*" & [Enter Customer Name] & "*". If the customer name is UPS, entering up will find it. If the customer name is jbhunt, jb or hunt will find it. But, if the customer name is consolidated freight, entering consol will not find it. Also, if the customer name is Hub Group, entering hub will find it. Can anyone see why this query fails on condolidated freight? Access97 running on NT 4.0.