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:] & "*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting and Separating Names in Access Query 2
Seperate First Name and Last Name 3
if statements in queries 9
query field names changing to expr#: 8
Find duplicates based on Last Name and the initial of First Name 7
Sometimes there a middle initial 5
aggregate function error 7
How to extract portion of text 5

Back
Top