Question cc Sorting reports into a specific order

E

espencer11

Is there a method for sorting a report in the design view by a
specific order, not just sort in ascending or descending order?
 
K

KARL DEWEY

You can build a sort translation table like this --
Order Char
1 D
2 B
3 Z
4 5
5 K
...
25 A
26 2
...
36 j

Then a calculated field --
MySort: IIF(Left([YourField],1)=[Trans].[Char], [Trans].[Order],"") &
IIF(Right(Left([YourField],2),1))=[Trans].[Char], [Trans].[Order],"")

This is for first two character but can be expanded.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

descending order 2
Sort Report by Month 1
Not Sorting Properly 2
Trouble with my sorting and grouping 2
Sorting records in the Report Design View 1
Sorting & Grouping Problem 4
Coordinating the sort order in a report with the underlying query 2
Sorting dates within groups. 2

Top