Perform query on first initial of last name - Help!

  • Thread starter Thread starter Brian newbie
  • Start date Start date
B

Brian newbie

I know this is an easy question. I would like to perform a query on
just the first initial of the last name. Can anyone kick me in the
right direction?
 
Hello,

If you wanted to pull all records starting with "a" you
would use a wildcard. So you would type a* in the criteria
field.

Amanda
 
I know this is an easy question. I would like to perform a query on
just the first initial of the last name. Can anyone kick me in the
right direction?
Click to expand...

The LIKE operator accepts "wildcards" - in particular, * for "any
string of characters". A criterion of

LIKE "H*"

will return Harter, Hotchkiss, Hughes, Hu and so on.

For more convenience use a parameter query:

LIKE [Enter initial of last name:] & "*"
 
Back
Top