Between is fine if you actually want a range, but if you want to match the exact values the you want Inlist instead.

If InList(n, 1, 2, 3) Then
   ...
EndIf

In the case of the example, the one you'd choose would depend on whether you are happy matching a range, in which case in Between, or an exact list of values, in which case you'd use InList.

Ian Simcock.


>(pointing out the obvious) This of course using BETWEEN makes the assumption that the expression can be expressed as a contiguous range of values (i.e. you don't need to exclude values within the range). It's OK as long as the question can indeed be expressed as "if X is between A and Z then ..", rather than being more of "if X is A, B, C or D then ..." (w/ potential for adding conditions T, X, and Y).
>>>
>>>by something shorter. I thought it would be something like if n in(1,2,3)