Concatenate field sorting

[Almac (Allan Macdonald)]

Hi,

I have created a baq to show the status of our manufacturing jobs and have created a calculated field that concatenates the operation codes to show them in a single field using the For XML Path method.
I have got my list however I would like to sort them by operation sequence but by default they are showing alphabetically which is difficult to read. does anyone know if this is possible?

[Banderson (Brandon Anderson)]

In the sub that you are concatenating, you can add the order by on the tab next to where you add the fields. Normally you can’t put an order by in there, but since you are using a single sub select, you can put an order by on that level.