Sorting in an access report? help

[davin2929]

I have a control in a report that contains a percentage and I want to sort the records by that control in descending order. When i do this it starts the sort at 0.0% and declines through all the negatives first rather than starting at 100%. does anyone have any suggestions. i'm stumped. thanks.

 

[Dugantrain]

That's an odd one, I would think that it would start from 100.0% and then go down from there. Either way, here's an all-purpose thing that I do when I want to have a large group of records sorted before another group. In the query that this report is based off of, add a field and call it something like 'Sort_Field'. Define it as:

Sort_Field:  Iif([Your_Calculation]<=0,1,0)

Now, when defining your Sort Order, first Sort on this field, and then Sort on the Calculation field. This will first sort every number greater than 0 above every number less than or equal to 0. Within that sort, you can sort Descending by your Calculation.