Filter based on first letter of last name

[Guest]

I have a query that includes a field name [last name]. I want to only inlcude
last name3s beginning with A-J. Is there a way to put this in a filter. I'm
sorry I'm brand new at this and I'm just kind of stumbling around. Thanks.

Mel

 

[John Spencer]

Try the following

Field: [Last Name]
Criteria: LIKE "[A-j]*"

 

[kingston via AccessMonster.com]

Use this as the field criteria for [last name]:

Like "[A-J]*"

I have a query that includes a field name [last name]. I want to only inlcude
last name3s beginning with A-J. Is there a way to put this in a filter. I'm
sorry I'm brand new at this and I'm just kind of stumbling around. Thanks.

Mel

 

[fredg]

I have a query that includes a field name [last name]. I want to only inlcude
last name3s beginning with A-J. Is there a way to put this in a filter. I'm
sorry I'm brand new at this and I'm just kind of stumbling around. Thanks.

Mel

Here's one way.
As criteria for the [Last Name] field, write:
Left([Last Name],1) Between "A" and "J"

 

[Guest]

Thanks a whole lot to both who responded.

Use this as the field criteria for [last name]:

Like "[A-J]*"

I have a query that includes a field name [last name]. I want to only inlcude
last name3s beginning with A-J. Is there a way to put this in a filter. I'm
sorry I'm brand new at this and I'm just kind of stumbling around. Thanks.

Mel

 

[John Vinson]

I have a query that includes a field name [last name]. I want to only inlcude
last name3s beginning with A-J. Is there a way to put this in a filter. I'm
sorry I'm brand new at this and I'm just kind of stumbling around. Thanks.

Mel

Use a criterion of

LIKE "[A-J]*"

The brackets indicate a list of desired matching characters; the
asterisk means match any string of characters after the first. Thus
"Anderson" and "A" and "Jenkins" would be matched; "Kevin" would not.

John W. Vinson[MVP]