I am using access 2010 and have a report that is driven off of a query. What I am trying to do is if the Field [BW] is >0 then sort Descending and if it is < 0 (meaning a negative number) then sort Ascending.
Basically if the number is greater than 0 sort like this example 6, 5, 4, 3, 2, 1
and if the number is less than 0 sort like this example -6, -5, -4, -3, -2, -1
This is driving me crazy
Any help would be appreciated
Bret