Select case

[arage]

Select case
I wrote the below but the second case does not execute for something like say, 1201. I was hoping for any insight. Please advise. This fragment appears in the format event of a header of a report grouped upon code.

Select Case code
'directors & sal coord...
Case 1100, 1200, 1300, 1400, 1500
Me.RegionDescription = DLookup("regionDescription", "Region", "code=" & code)
'managers...
Case Not (Right(code, 2)) = 99, Not (Right(code, 2)) = "00", Not (code) > 1599
Me.RegionDescription = DLookup("regionDescription", "Region", "code=" & code)
'others...
Case Is > 1599

End Select



[This message has been edited by arage (edited 03-20-2002).]

 

[Rich]

1201's not on your list.

 

[arage]

but 1201 satisfies the condition set by the second case doesn’t it?

 

[Rich]

I'm not sure but I think it should be Case 1100 To 1599

[This message has been edited by Rich (edited 03-20-2002).]

[This message has been edited by Rich (edited 03-20-2002).]