Sorting help with negatives

[jaburke]

Hey,
I want to sort a field containing numbers. For example:

-9
-13
9
10
12
13

How can I create a formula to do this? Right now it is doing this:

9
-9
10
12
13
-13

 

[synapsevampire]

Right click the field and select browse data, it's probably recognized as a string.

Write a formula of val({table.field}) and use the formula for sortation.

-k

 

[jaburke]

When I use that formula in my 'If' statement, I get an error that says 'a string is required here'.
I am adding this one line to an existing formula and all the other 'If' statements have converted numbers to strings for sorting. Why - I don't know.
How can I suppress that error and why is it happening? Ideas??

Much thanks..

 

[jaburke]

I found the answer in another post. I didn't see it yesterday when I searched.

Thanks!

 

[Madawc]

Glad you've solved it. But it's helpful to say what the solution was, in case someone else has something similar.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10