Order By in a Form

[PaulJK]

I have a form where the position for one field can be: Outstanding, Declined, Current or Cancelled.
Currently I order: qryProposals.PropStatus DESC, qryProposals.PropDescName.
I would like to order, but not in a ascending or decending manner.
For example: Outstanding, Current, Declined, Delisted and finally Cancelled.
I have tried various options in the ORDER BY field, but nothing works.
Any quidance would be helpful.
Thank you.

 

[Geezer]

Can you not add another field and assign numbers to each status, e.g.

Order Field, Status Field
1,Outstanding
2,Current
3,Declined
4,Delisted
5,Cancelled

Then order the form by the Order Field.