Perform query on first initial of last name - Help!

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?
 
A

Amanda

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
 
J

John Vinson

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:] & "*"
 
Top