alpha range

[Guest]

is there a way to use between parameter for alpha range?
for example I want to pull customer name between abe and arq

i've tried between "abe" and "arq" , between "abe*" and "arq*" , between
"abe?" and "arq?"
but it's not pulling all the records.
Thanks!

 

[BruceM]

Try Between "abe" & "arr"

 

[Guest]

nope..
i don't think u can't use "&" with between.... it gave me an error message...

 

[BruceM]

Sorry. That was supposed to be the word And:

Between "abe" And "arr"

 

[Douglas J. Steele]

What happens with BETWEEN "abe" AND "arq"? I would expect that to work, to
a point. It return find names like abe, abernathy, anderson and arq, but not
arquette.

You might want to try

WHERE NameField >= "abe" AND NameField < "arr"

 

[Guest]

ok that worked. why would i have to put "arr"?
ok since that worked, here's another question.
I actually have a table setup with people's name and the alpha range from
and to.

I wanted to look up between value using that table, so without me having to
change the value to next character manually.. how would I go about doing so?
example:

name from to
jane doe abe arq
jim bob ast awz

 

[Guest]

I already have a table set up for each collectors the alpha range.
without me having to change the last character to next one up.(like q to r) ..
is there a way to do look up using the values in the table?

 

[BruceM]

It will find everything up to "arq", but as soon as you add another letter
Access interprets the value as being greater than what you specified. By
using "arr" you will be finding everything up to and including "arr" (which
means everything starting with "arq" plus the word "arr". I think "arqz"
would have worked, too.

To the second question, you could use:
Between [Start] AND [End], which would prompt you for the parameters. If
that does the trick we can look at ways to refine the interface to make it
easier to use.

 

[Douglas J. Steele]

You'll have to give more details about this table.