Manually sort text in report grouping (other than A to Z, or Z to A)?????

[MaggieN]

Hello,



I have a simple 4 column report with detail grouped by Age. The age field (very left column) has a text property (e.g., "0-90 days", and thus is sorting only from A to Z or Z to A). Is there any way to MANUALLY ARRANGE the way groups are listed in my report? I need the report to look like this with this sort order:

Age:
"0-90 days" (first group)
"90-180 days"
"180 - 365 days"
....
"1-2 years"
"2-3 years"
....
"20+ years" (last group)

Instead I am getting this order (bcs the text sort recognizes only first number, then second number, etc..):
0-90 days
10-15 years
20+years
....

I created this report using the Report Wizard, with Grouping by Age. (Thus only grouping options are either "Normal", or 1st letter, 2nd letter, 3rd letter, etc.. = not helpful). Please HELP! Thank you!

[ranman256]

theres no manual, but when you build your Group name, use a table, the table will have sort order.
tGroups
-------------
[Grp], [GrpSort]
"0-90 days" , 1
"90-180 days",2
"180 - 365 days",3

then when you join it in your query , you can use the sort order ,(not the text)

[MaggieN]

Thank you, I actually already solved it - I created a separate column in my table called Age Rank. Assigned 1 to first group (e.g., "0-90 days" = 1, "90-180 days" = 2, etc.). Then when using the report wizard, I grouped based on "Age Rank" and then on "Age", and then I just made the Age Rank not visible in the actual report... It kept the rank order for Age that way.

Thanks anyway.

[ranman256]

That's what the table does.