many sort criteria for one group in access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Within one group I have, let's say, a return that starts with "A" and "B and
"C".
if the value starts with "A" I want to sort by field [x] if it starts with
"B" sort by field [y]... etc.
 
Create a calculated field like this ---
Sort_Field: IIF(Left([Z],1)="A", [X], IIF(Left([Z],1)="B", [Y], [Z]))
 
Back
Top