I have modified a form for using inventory. In the subform there is a comments field with the following: =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
Now, the history is working fine, but it puts the most recent update after earlier updates (in other words the oldest update is displayed at the top). How do I reverse the date/time order to show the most recent update (descending order)?
Thanks in advance!
Now, the history is working fine, but it puts the most recent update after earlier updates (in other words the oldest update is displayed at the top). How do I reverse the date/time order to show the most recent update (descending order)?
Thanks in advance!