how do I sort data that return name start with O to Sn?

[ges]

I like to sort data that return company name that start with O to Sn, then
from So to Z
In creteria I type: Like"[O-Sn]* but it also return record that start with N
Can any one HELP? Thanks!

Ges

 

[Dawn]

try this.

 

[Lord Kelvan]

are you trying to do that in one query because it is going to just do
o -z if you want to do it quickly rather than having to go in and
manually change the criteria each time enter >=[start letter]* and
<=[end letter]* adn that will give you prompts so you can do it quickly

 

[Lord Kelvan]

sorry that was supose to be

Between >=[start letter]* and <=[end letter]*

in to the criteria box

 

[John W. Vinson/MVP]

sorry that was supose to be

Between >=[start letter]* and <=[end letter]*

in to the criteria box

Actually that won't work either; you're not concatenating the asterisk
to the prompt, and wildcards only work with the LIKE operator, not the

= or <= operator.

Try >= [start letter] AND <= [end letter] & "ZZZZZZZZZZ"

assuming you'll never have a legitimate hit ending with more than ten
z's.

 

[John Spencer]

For the first instance:
Field: Company
Criteria: >="O" and < "So"

For the second instance:
Field: Company
Criteria: >"Sn"

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[ges via AccessMonster.com]

Thank you ALL for your responses. I appreciate all of you.

Thanks,
Ges

For the first instance:
Field: Company
Criteria: >="O" and < "So"

For the second instance:
Field: Company
Criteria: >"Sn"

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I like to sort data that return company name that start with O to Sn, then
from So to Z
In creteria I type: Like"[O-Sn]* but it also return record that start with N
Can any one HELP? Thanks!

Ges