I want to write a formular that can select the number in a specific interval. for example, I want to use fulter tool to pick 2,3, and 4.
If I use 【n IN (2,4)】, then I can only get 2 and 4. Can I use a simgle expression to do this job?
Thanks to reply, I wonder if there exist a shorter expression, such as 2 <= [n] <= 4 (I have tried this expression, didn't work) that only need one [n].
That wouldn't be a valid expression within the Filter tool.