Sort MSFlexGrid

[vbpadawan]

Is there a way to sort two columns in the flexgrid? I need one column sorted ascending and the other sorted descending. I populate the flexgrid with a recordset but several of the columns are calculated fields that I compute in code and not in the query.

 

[vbpadawan]

In doing some searching around, I have discovered that you can only sort consecutive columns and all in the same direction. If this is the case, this won't work for what I need to do. Does anyone have any ideas on a different way to do this? I have a recordset that I load into the flexgrid and some of my columns are calculations based on my recordset fields. I need to sort one column ascending which is a field in my recordset and I need to sort another column descending which is one of my calculated fields.
Hope this makes sense.
I've considered creating a UDT and creating an array of that type but can I sort those?
Thanks for any help you can give me.