Query sorting numbers not working, sort is ignoring negative signs

[cowboy]

I have a query with has a computed field which if there is not a date that the project is completed it takes the logged date - the due date to return how many dates left or past due. The query is:


DaysLeft: IIf(IsNull([Completed]),[Due]-Date(),"")
When I run the query I get something like this:

Then I use the sort A to Z as shown here:

and the following are the results:

Any ideas on how to get the numbers to sort from the largest negative number to the largest positive number?

Also is there a way to sort from the largest negative number to the largest positive number and have the blanks at the end?

Thank you for any input you might have.

-Dan

[orange]

??? If Completed is not Null --that is, has a value -Do you want to report completed?

[June7]

You are using empty string for the alternate value. Forces all values to be treated as text, not numbers and apparently the negative sign is a secondary order so they follow the positives for the same 'number'. Use Null instead.

Null and empty string will always sort first Ascending and last Descending.