query to find field value of alphabet

  • Thread starter Thread starter jag
  • Start date Start date
J

jag

I would like to create a query for a field called street name. I would like
the user to only have to put in the first alphabet letter of the street name
and all streets with that first letter would appear. I'm unsure how to
accomplished this. I have used: Like [street name], but that requires the
entire name to be entered exactly like it is on the list.
 
I would like to create a query for a field called street name. I would like
the user to only have to put in the first alphabet letter of the street name
and all streets with that first letter would appear. I'm unsure how to
accomplished this. I have used: Like [street name], but that requires the
entire name to be entered exactly like it is on the list.
Click to expand...

Try

LIKE [Street name:] & "*"

The * is a wildcard that will return MAIN and MARQUETTE and MURPHY
when the user types M.

You may also want to look into using a Combo box based on a query
listing all streetnames - the combo will autocomplete, i.e. jump to
the first M when you type M, to the first MU when you type that.
 
Back
Top