access query to list names starting with H

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

Guest

I am trying to run a simple access query
I have a database of names - first name, last name
I would like to create a query - where it shows the entries , where the last
name begins with H. I have used " H" as the criteria , and that does not
work.

help
 
Are FirstName and LastName 2 separate Fields in your Table?

If they are (and they should be), simply add the criteria:

Like "H*"

in the LastName Column of your Query Grid.

If they are combined into a single Field, suggest you re-structure your
Table and use 2 separate Fields.
 
Back
Top