AnsweredAssumed Answered

Finding Records By First Word In Field

Question asked by JoeQuinlivan on Feb 18, 2011
Latest reply on Feb 18, 2011 by philmodjunk

Title

Finding Records By First Word In Field

Post

I have my database almost finished but can't figure out how to make this work.

 

When I go to find mode, it returns all records that have the search criteria anywhere in the field's text.  Example:  I need to find a company called "Baker Trucking Company".  So I enter "Baker" in the company field and it returns every company that has "Baker" in the field such as "Bob's Bakery".  I need it to return only companies that start with "Baker".  An example of what it should return would be "Bakery Products", "Baker & Baker", "Baker Trucking". 

 

Any ideas?

Outcomes