I have "order by" in a form: nz([kolejnosc], 9999]) - to have null field a the end not at the top.
kolejnosc it's a long field. form based on query (union all)
If I have records with (1,2,3,4,5,6,7,8,9) everything is ok but when I have "10" number then my sequence is (1,10,2,3,4,5,6,7,8,9)...