History column for date field (1 Viewer)

[Ravi Kumar]

Hello all ,

In my data entry from i want to have a history column which shows the previous version of change :
i have done this for long text field by making the field as append only but now i want to have the same for the column having"Date type" where the table design is not sowing this property.
please help me how to do this..

=ColumnHistory([RecordSource],"Previous Calibration","[ID]=" & Nz([ID],0))

 

[arnelgp]

columnhistory applies only to Memo (Long text) field.

 

[onur_can]

You can follow a path like this;
Create a new field in the query and name it Date and History, then as an expression;
Set Date & "-" & History. Hide other Date and History columns, uncheck Show. Now Date and History will be shown in the same column.

 

[isladogs]

See if this article helps: http://www.mendipdatasystems.co.uk/column-history-memo-fields/4594523656