What about these?
First one works for sure.
Code:
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.
Code:
'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
Bookmarks