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