Non-Standard sorting of records

[Michael A. Bennett]

How can I sort the records for my report in a non-standard way?

I have a field that has three possible values: 'D', 'L' and 'N'. I would
like these records to be sorted as 'L', 'D' and 'N'. I could create a table
with these values and a corresponding sort value, but is there another way
to do this?

Thanks for your help!
Mike

 

[Rick Brandt]

How can I sort the records for my report in a non-standard way?

I have a field that has three possible values: 'D', 'L' and 'N'. I would
like these records to be sorted as 'L', 'D' and 'N'. I could create a table
with these values and a corresponding sort value, but is there another way
to do this?

Sort on the expression...

IIf([FieldName]="L","A", [FieldName])