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...