Inclusive Alphabetical range in query expression 3

[Vie]

This is probably a pretty stupid question but I'm trying to get a query to return a range of names, for instance, all people whose last names begin with A through all those people whose last names begin with P. No matter what expression I use, it seems to be up to P and not through P.

Between A And P GIVES A up to P
>=A And <=P GIVES A up to P
>A And <=P GIVES A up to P

Anybody know how to do this? I'm just not getting it.

Vie

 

[sxschech]

This example provides A through P including P...

SELECT tbl.LASTNAME
FROM tbl
WHERE (((Left([LastName],1)) Between "A" And "P&quot)
ORDER BY tbl.LASTNAME;

 

[TonyJollans]

Hi Vie,

Perhaps a bit of explanation would help.

I guess you are checking the whole of LastName, rather than the first character. The problem with this is that "POE" or "PEABODY" or whatever are all greater than "P". You can go with sxschech's solution or change what you are doing to be [blue]< "Q"[/blue]

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[Golom]

Or you could use LIKE

SELECT tbl.LASTNAME
FROM tbl
WHERE [LastName] LIKE '[A-P]*'))
ORDER BY tbl.LASTNAME

 

[Vie]

All good suggestions and all work. And Tony, thanks for the explanation - now I get it! So, basically if I add a z (eg Pz) then all the last names beginning with P will be returned.

Thanks sxschech, Tony, and Golom!
Vie