I want to sort a report based on criteria in a Query
If the Text in the sorting column of the Query is either Beginning, Middle, End, Other or a blank space. How can I sort the Report in Ascending chronological order: Beginning, Middle, End, Other, blank space as opposed to in Ascending in alphabetical order: blank space, Beginning, End, Middle, Other which is how it is now?
Does this make sense? I am lost!