Perform query on first initial of last name - Help!

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

 

[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

 

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

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