Non-Standard sorting of records

  • Thread starter Thread starter Michael A. Bennett
  • Start date Start date
M

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
 
Michael A. Bennett said:
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?
Click to expand...

Sort on the expression...

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