Sorting Numeric Data in Text Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

Josh said:
I have a field(text data type) in a query and it contains numeric data.
Click to expand...
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.
 
Back
Top