Select case...Just wondering....

[sayzer]

What about these?


First one works for sure.

SELECT CASE x        

     CASE IS < 21   'Between 0 and 20; including 20.

     CASE IS > 20 AND IS < 41 'Between 21 and 40 ; including 21 and 40.

     CASE IS > 40 AND IS < 61  'Between 41 and 60 ; including 41 and 60.

END SELECT

For this second one, I expect someone to confirm.

'Once it hits the first matching condition it should not go to the next one.
'Or will it?

SELECT CASE x        

     CASE IS < 21 'Between 0 and 20; including 20.

     CASE IS < 41 'Between 21 and 40 ; including 21 and 40.

     CASE IS < 61 'Between 41 and 60 ; including 41 and 60.

END SELECT