Value List Sort Descending by Timestamp

[Dre]

Hello. I have been browsing the current topics, looking for a solution to my dilema, and have not found one. Maybe I am searching the wrong topic?

Here's my issue: I have created a Comments table, related to Jobs, and would like to display all related comment records in a large concatenated text field. It will allow user to view entire comment and timestamp vs using a portal (since length of comment is unknown).

However, I would like to sort descending, based on the timestamp, so the most current comment is always at the top of the list.

What I have so far seems to function, but I cannot figure out how to reverse sort the value list. Any help would be appreciated.

Field (Calc) Jobs::Comment_Viewer = ValueListItems ( "Quotes" ; "Job_Comment_Viewer" )

Field (Calc) : Comments|Jobs::c_Comment = Timestamp & " " & AccountName_Created & " " & Comment_New

Field (Text) : Comments::Comment_New

Value List : Job_Comment_Viewer = Use values from field : Comments|Jobs::c_Comment

Please let me know if this is enough information to go off of, or what else I may need to specify to get some help.

Thanking you in advance.

[comment]

Define a calculation field cNegTime (in Comments table, result is Number) =

- Timestamp

Define your value list to also display values from cNegTime, and to sort by second field.

[Dre]

Thanks! It worked! Crazy how it can be the simplest idea that escapes your mind. I appreciate your help.