sorting a numeric field

[rll111]

I've created a database of items with over 1,000 entries, and have now been asked to sort the items by value, giving a report on items with a value over $2,000. I have a numeric field for each item. However, the descending sort gives me all entries starting with a 9, whether 90 or 9,000, then all entries starting with 8, etc. Can anyone help?

 

[suesloan]

Apparently your value field is defined as "text" and not as "numeric". You can leave it that way and define a calculated type field with a formula like this:

yourvaluefieldname * 1

Now sort your report on the calculated field.

Sue Sloan