How to use =ColumnHistory in Report coming from a different query/table?

[LevyEdge]

Hello All! First post here.



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?

[ranman256]

Try not to do any data calls in the report, do them in the query.
The query should provide all the data needed to display.

[CJ_London]

I seem to recall that columnhistory only works with a table and the history is not passed on via a query, so presumably your 'cases query' is based on the cases table which contains the comments field. If this is not providing what you require, try changing [Recordsource] to "Cases"

Alternatively, take a look at this link

http://stackoverflow.com/questions/3...in-access-2007

[LevyEdge]

http://stackoverflow.com/questions/3...in-access-2007

This worked, thank you!