modifying the column sort

[JohnE]

In a gridview the Sort is allowed so the column headers are underlined. The
sorting that is done thru this method is okay. The exception is a column
called 'Status' which the users want to have is sort the way the workflow for
the status occurs. In Access I added a column to the status table for the
workflow sorting. The workflow status sort column still exists in the table
but how do I apply it to the Status column in the gridview? This would be
when the user click the column header (same as the others) and the sorting is
done by the workflow rather then the standard sorting the allow sorting does?
Samples and links are helpful as well.
Thanks.
John

 

[Guest]

In a gridview the Sort is allowed so the column headers are underlined.  The
sorting that is done thru this method is okay.  The exception is a column
called 'Status' which the users want to have is sort the way the workflow for
the status occurs.  In Access I added a column to the status table for the
workflow sorting.  The workflow status sort column still exists in the table
but how do I apply it to the Status column in the gridview?  This would be
when the user click the column header (same as the others) and the sorting is
done by the workflow rather then the standard sorting the allow sorting does?
Samples and links are helpful as well.
Thanks.
John

Can you share your code on how you setup the gridview? I think you
need to change a query for the data source....