Sorting Numeric Data in Text Field

[Guest]

I have a field(text data type) in a query and it contains numeric data. Because this is a text field(and I can't change it, it is a linked table to someone else's database) I can't sort the data correctly

Example

28
2

I need

2
28

How can I do this

Thanks

 

[Cheryl Fischer]

Try adding a calculated field to your query, as follows:

SortOrder: Val([MyField])

Then set the Sort: property in that column to Ascending and remove other
sorts


hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have a field(text data type) in a query and it contains numeric data.

Because this is a text field(and I can't change it, it is a linked table to
someone else's database) I can't sort the data correctly.