Finding Records By First Word In Field
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".