Custom sort Report by Combobox

[TerribadCoder]

Hi again, all! I was wondering is this was possible in access. I've read material on grouping and sorting, but haven't been able to pin down what I need.

I have a combobox field that has 14 entries, beginning with 01 as the first two characters. What I'd like to do is change the order in which everything is displayed on the report.

For instance, show 07 at the top, then 09-13 below that, and so on... Is there a way to do this? Thanks for your help!

 

[pbaldy]

If you're looking for a non-alphabetic sort, it can be done by adding a sort field to your table, so you'd have this type of thing

07 - 1
09 - 2
10 - 3
01 - 4

In the report's source query, you'd join in that table so you could include the sort field.

 

[TerribadCoder]

I should have also stated that the combobox on which I'm trying to sort by is alphanumeric. The first two characters of each value is numbers, but the rest is not.

Additionally, sorry still a bit new to access, what do you mean by join in that table to include the sort field? Wouldn't I be adding this field to the table the combobox field on which I want to sort resides in?