Sorting numbers (text) in a report

[kids7]

When sorting numbers in a text field in an access report I get 1,10,100,101,102,......then 2,20,200,201 and so on. How do I get the sort to be 1,2,3,4 etc.

Thanks

 

[GingerR]

you can make a calculated field in your query that your report is based on. make it

=cint([field])

then use that field to sort/group on in the report, but don't display it if you don't want to.

or you can put an unbound text box on your report, and put in the same type of formula. cint means Convert to Integer.
whatever works for your particular case.