how to Sort the results of using the columnHistory() function?

[Eredhil]

I am using the sales Access templante, in one part is using the

 =ColumnHistory([RegistryOrigin],"Comentaries","[Id]=" & Nz([ID],0))

to show all the comments made but it is not showing them sorted , I need to modify the above code in order to make it show them in a sorted list from the newest input to the oldest.

Thanks!

[alansidman]

Where are you trying to do the sort. Easiest place is in a query. In the QBE, there is a section that offers a sort feature.

Alan

[Eredhil]

In the Access Business template, a pre-created form uses this function, where it has a section where you input a new comment and right below it has the "history" of all the comments previously stored, if you change to design view, you will see in the "history section" the code that I posted earlier. The problem is that the comments are not sorted by date, I only want to sort them by date, but have no idea on how to use the sort feature inside columnhistory syntax.

Where are you trying to do the sort. Easiest place is in a query. In the QBE, there is a section that offers a sort feature.

Alan