Order by in a form

[radek225]

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). What should I do to achieve the correct sequence?

 

[JHB]

It looks like your field type is text.

 

[radek225]

It looks like your field type is text.

No in both tables it's a long

 

[JHB]

Show some sample data, + the query for the form!

 

[arnelgp]

order by: Format(nz([kolejnosc], 9999), "0000")

 

[radek225]

Show some sample data, + the query for the form!

thank you for your insight
Format(nz([kolejnosc], 9999), "0000") solved my problem.