Sort Negative First

[Crilen007]

When i sort values, for some reason the negatives are at the top, followed by the highest positive values. Anyway to turn this off?
Tried google and searching these forums.

 

[RuralGuy]

It sounds like you are sorting Text fields rather than numerical values. BTW, if you are sorting ascending, where would you expect the negative values to be located in the sort?

 

[RoyVidar]

Fieldsize Decimal? If so http://support.microsoft.com/kb/837148

 

[Crilen007]

I'm sorting Decending.

I'll check the above article.

 

[Crilen007]

That fixed it for the table view, but not for the report =(

 

[RuralGuy]

Reports have their own sorting and grouping. Is that what you are using?