Query Trouble (1 Viewer)

[dennis g]

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.

 

[dennis g]

Never Mind

Never mind. Figured it out. Was using another table to add the customer name. It was hanging up on Consolidated Freight, it was in the table different.