Hello All,
I use the following code in access as a way of capturing comments so my colleague and I know where we are at any given time, however I have noticed that the entries are not displaying sequentially?
=ColumnHistory("tbl - Issues","MemoField","[ID]= " & Nz([ID],0))
In the picture below it has kept sequentially but not in the way we want.
In the picture below, it's not in the right order. its shows newest to top and oldest to bottom?
How can I tell access to display it as newest first always.
Thanks
Stuart
I use the following code in access as a way of capturing comments so my colleague and I know where we are at any given time, however I have noticed that the entries are not displaying sequentially?
=ColumnHistory("tbl - Issues","MemoField","[ID]= " & Nz([ID],0))
In the picture below it has kept sequentially but not in the way we want.
In the picture below, it's not in the right order. its shows newest to top and oldest to bottom?
How can I tell access to display it as newest first always.
Thanks
Stuart