Query criteria

  • Thread starter Thread starter Tut
  • Start date Start date
T

Tut

Hello, I am trying to find the following in a field, the name "kennel"
I have several thousand records that contain the word kennel in the business
title:
Business Name:

Happy tails kennels.
Johns kennels and boarding.
Kennels and boarding by Mary.
Kennedy's dogs.
Bobs kennel and boarding.

How, in the criteria can I select only the word "Kennel or Kennels" for this
field?

Thanks in advance.
Bob
 
Thanks, what worked, was *kenn* in the criteria.
This turned on the LIKE "*kenn*" statement which worked perfectly.
Thanks for your help.
Bob
 
Back
Top