C
Chuck
If you have values a, b, c in field Y in table X and you want to sort them b,
a, c in a report:
Base the report on a query. In the query make a calculated field SortOrder.
SortOrder: IIf(Left([X]![Y],1)="a","2 " & [X]![Y],IIf(Left([X]![Y],1)="b","1 "
& [X]![Y],"3 "&[X]![Y]))
Make this be the first field in the query. Sort this field ascending, but
don't print it.
Obviously, if the original field Y has only a single character, you don't need
the left command.
Chuck
--
a, c in a report:
Base the report on a query. In the query make a calculated field SortOrder.
SortOrder: IIf(Left([X]![Y],1)="a","2 " & [X]![Y],IIf(Left([X]![Y],1)="b","1 "
& [X]![Y],"3 "&[X]![Y]))
Make this be the first field in the query. Sort this field ascending, but
don't print it.
Obviously, if the original field Y has only a single character, you don't need
the left command.
Chuck
--