Hello folks!
I created a query to select only odd and even numbers using MOD 2 = 0 or 1 and it works fine. I set up this numeric field to sort ascending. But my sorting is wacko. Please help!
When I run the code, I get 1, 11, 12, 2, 20, 22, 3, and so on.
The same when I do the even sort, 2, 20...