Number Sorting Problem in Query

[csprop]

I have this one query in my database which is sorting a field containing numbers only by the first digit (i.e. 16 comes before 9, since 9 > 1).

This query gets its data from a table which is created by two append queries. This table has the same problem, which I assume is creating the problem in the query mentioned above.

Every other table and query (including the two append queries) sorts correctly. What is this table's issue? Why will it not sort correctly? I assume it has something to do with the fact it gets its data from two append queries.

Any help would be VERY much appreciated, because this has been a royal headache for me.

Thanks.

 

[Brianwarnock]

Sounds like it is a text field

 

[csprop]

I've tried it as a text field and a number field and had the same results.