Query on one part of a Database record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a Form in which a user is prompted for a road name and
a listing of all values having that road name are displayed. My problem is
that Road Name in the database is a combination of the road name and road
suffix such as Evergreen Street. I want the operatior to be able to enter
just the road name, Evergreen, and get a listing of all Evergreen addresses;
Evergreen St., Evergreen Rd., Evergreen Ln., etc. How do I create the prompt
so that it ignores the road suffix and searches just on the name?

Thanks For Any Help
 
I should add a little more to my question.
I know how to use brackets in a form prompting the user to input a
parameter. In a query I can use "*" to find all those records having a
portion of the desired data. For example in my query I can use "Evergreen*"
to find all records where the fisrt portion of the data record is Evergreen.
How can I apply the "*" to a user entry prompt.

Thanks
 
Back
Top