How to change a sort

[darkhat01]

I have a report that I created, I want to sort the report by the words High, Medium, low. But if I use ascending order I sort by High, Low, Medium, and if I sort by descending I sort by Medium, Low, High. How do I fix this so I sort by High, then Medium, and finally Low.

Thanks,

Darkhat

 

[Remou]

I think you will need to add a sort number through a query.

 

[dhookom]

You can create an expression in the Sorting and Grouping like:
=Instr("HML",Left([Some Unknown Field Name],1))

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[darkhat01]

I like that dhookom thanks.