Creating query which uses first letter of last name as a range

[kukady]

Hi everyone,

Apologies in advance as I'm somewhat of a novice with Access. I use an Access project (2002 SP3) via XP and am trying to create a query which will show me a range of last names beginning wiht the first letter. The results I want to see are where last name = A through K, for example, so that it only returns records with last names begininning with these letters. Any ideas as to how the criteria should be written? Thanks!

[NeoPa]

SELECT Blah Blah Blah
FROM Table
WHERE (Left([LastName],2) Between 'A' And 'KZ')

[kukady]

Thanks a lot. Worked like a charm!

[NeoPa]

You're welcome - pleased to have helped :).

[ADezii]

Hi everyone,

Apologies in advance as I'm somewhat of a novice with Access. I use an Access project (2002 SP3) via XP and am trying to create a query which will show me a range of last names beginning wiht the first letter. The results I want to see are where last name = A through K, for example, so that it only returns records with last names begininning with these letters. Any ideas as to how the criteria should be written? Thanks!

'If you are doing this from the Query Grid then in the Criteria Row of the Query
'Grid for the desired Field, type Like "[A-K]*" as the criteria

[NeoPa]

'If you are doing this from the Query Grid then in the Criteria Row of the Query
'Grid for the desired Field, type Like "[A-K]*" as the criteria

This is a MUCH better answer (Thank you ADezii).

SELECT Blah Blah Blah
FROM Table
WHERE ([LastName] Like '[A-K]*')