Between...And aka Rock and a Hard Place

  • Thread starter Thread starter Gdub
  • Start date Start date
G

Gdub

I have a form that batches products by last name, based
upon ranges selected by the user: i.e., A-G, H-M, N-S and
T-Z. The Form Fields are Range1, Range2 and a hidden
Range2a. When the customer selects the A-G button, it
pops in "A" in Range1 and "G" into Range2. The hidden
Range2a becomes "H". My query that returns the customer
data has a criteria under last name like so: Between
[Forms]![JMultBatcher]![Range1] And [Forms]![JMultBatcher]!
[Range2A]. It returns all customers between A-G, the
desired result.
However, when there are customers who happen to have a
last name starting with "Z", I have no higher range to
reference. I'm sure there is a better overall way to do
this, hence my plea. Many thanks in advance.
 
I have a form that batches products by last name, based
upon ranges selected by the user: i.e., A-G, H-M, N-S and
T-Z. The Form Fields are Range1, Range2 and a hidden
Range2a. When the customer selects the A-G button, it
pops in "A" in Range1 and "G" into Range2. The hidden
Range2a becomes "H". My query that returns the customer
data has a criteria under last name like so: Between
[Forms]![JMultBatcher]![Range1] And [Forms]![JMultBatcher]!
[Range2A]. It returns all customers between A-G, the
desired result.
However, when there are customers who happen to have a
last name starting with "Z", I have no higher range to
reference. I'm sure there is a better overall way to do
this, hence my plea. Many thanks in advance.
Click to expand...

I'd set Range2a to Range2 & "{" - the left curly bracket character
comes right after "z" in the sorting sequence, so this will give you

BETWEEN "T" AND "Z{", which will pick up everything up through ZZZZZZ.
 
Back
Top