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