Custom sort on a report 1

[tongaman]

Is there a way that I can apply a custom sort in a report rather than the default sort ascending and sort descending.

For example, if I have a field with values "a b c d", can I sort in my report to get "C B D A" rather than the default ascending "a b c d" and descending sort functions "a b c d".

Thanks in advance.

 

[THWatson]

tongman
Microsoft Knowledge Base has an article, #304564, about how to do a custom sort, using the Switch function.

Here's the link...

http://support.microsoft.com/?kbid=304564

Hope that helps.

Tom