Range

[Dan @BCBS]

In the code below, how can I change "99999-pbd" to the range of "99995-002"
thru "99995-022" ????


Left(rstemp!MBR_GROUPNO, 9) = "99999-pbd"

 

[kingston via AccessMonster.com]

I'm not sure if this is what you mean:

For i = 2 to 22
[NewNum] = Left([OldNum],6) & Right("00" & i, 3)
'assume [NewNum] is saved
Next i

 

[Dan @BCBS]

No, is there a way to say something like:
Left(rstemp!MBR_GROUPNO, 9) between "99995-002"
and "99995-022"

or >"99995-002" and < "99995-022"

Somthing like that - any suggestions?????
I only want to capture a range, no other changes if possible....

Thanks

I'm not sure if this is what you mean:

For i = 2 to 22
[NewNum] = Left([OldNum],6) & Right("00" & i, 3)
'assume [NewNum] is saved
Next i

In the code below, how can I change "99999-pbd" to the range of "99995-002"
thru "99995-022" ????

Left(rstemp!MBR_GROUPNO, 9) = "99999-pbd"

 

[kingston via AccessMonster.com]

If I understand correctly, you might try to do this in two parts:

Part 1: Left([Field],5)=Left([ValueStart],5)
Part 2: Right([Field],3) Between Right([ValueStart],3) and Right([ValueEnd],3)


Part 1 and Part 2 must be true.

No, is there a way to say something like:
Left(rstemp!MBR_GROUPNO, 9) between "99995-002"
and "99995-022"

or >"99995-002" and < "99995-022"

Somthing like that - any suggestions?????
I only want to capture a range, no other changes if possible....

Thanks

I'm not sure if this is what you mean:

[quoted text clipped - 7 lines]