I am actually learning a few things here and there and I am trying to figure out how to use ColumnHistory in a report.
I was using the provided "Call Log" template provided by Access and I noticed they used ColumnHistory in one of their reports. So I did a similar report but using the same command:
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
But what I noticed is that it is using the "Cases" Table as the Record source. I did the report using the record source as a query called "Cases Query"
I am not sure how to actually pull the appended information that is stored in the Cases Table to my report that is using a query as the record source.
Would anyone have the information to help me with this?
I was using the provided "Call Log" template provided by Access and I noticed they used ColumnHistory in one of their reports. So I did a similar report but using the same command:
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
But what I noticed is that it is using the "Cases" Table as the Record source. I did the report using the record source as a query called "Cases Query"
I am not sure how to actually pull the appended information that is stored in the Cases Table to my report that is using a query as the record source.
Would anyone have the information to help me with this?