ColumnHistory to display on report

[JHamrick]

I am using this code to track and display historical entries entered into a "Comments" field everytime a user adds comments to a record. The field is a memo field with Append Only property set to Yes. This code works fine when used as an unbound field on a form, but I keep getting an #Error when displaying it on a Report. My intent is to have the historical entries display on a report as well. The report source is a query, so it is only returning the last entry made. Is there a better way to save historical entries with a date/time stamp for a record?

Code used:

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

[Mihail]

How you store this comments in your database ?

[JHamrick]

The "Comment" field is a memo type.

[NeoPa]

As you give us so little information my answer must be very general, but I'd suggest you build the report based on a query that supplies the data you need to include in it.

[JHamrick]

What more info do you need? Any explanation on how to use the ColumnHistory function to display results on a report?

[NeoPa]

Have a look at Access Answers Forum. There are two threads there you should have read that explain what you need to do when asking a question. If I'm doing that for you then I'm only going to encourage what is frankly a poor approach and attitude on your part.

Let us answer the questions and we'll leave you your responsibility, which is to ask them correctly.