Sorting non-ascending or desending

[businessman]

I have a Field that has the values High, Med, and Low. I want to have a header in the report sort High, Med, then Low and not alphabetically. Can I do this?

 

[Banana]

Yes; if you have the table set up in this order, leaving the query unsorted will return just that.

 

[*Pete*]

Hello, if the Report is based on a query you could add the following field to the query.

SortOrder: IIf([Value]="High",1,IIf([Value]="Medium",2,IIf([Value]="Low",3," ")))

Where [Value] is the name of your field that contains the values High, Medium & Low.

You will then be able to sort on the numbers.

Regards

Pete

 

[businessman]

I'm confused as to how you add SortOrder as a field. Do I just title it as SortOrder? then where do I put the if statment?

I also changed the order in which High Med and Low appear in my table and they changed back to the order they were in before. Is there a way to move the record order without hurting the records that use this table? for example, This table is called urgency. the records are High Med and Low. Each of these have other records that are attached to these since these values are used in a combo box in another field. how do i change the order or them in the table?

 

[Banana]

If you've already created the table and records already refer to it, changing it wouldn't be good idea.

I'd imagine you'd put Pete's SortOrder: in the Sort by: row, just as you would create an expression in the Field row.