I need to create a compound tag that all fields are in ascending order except for the date which is in decending order.

I need to show a parts table that has superceding and preceding parts in it. The latest date for each part has to be on top of the display and the parts have to be in ascending order.


Example:

Item Superceding Date Entered
------------------------------------------------------
A1Muffler A1AMuffler 03/28/02
A1Muffler A1XMuffler 03/25/02
BlowoffValve BOValve 03/28/02
BlowoffValve Bvalve 01/01/01

Item has to be ascending and date entered has to be descending for each part.


Thank you,
Geoff