Help with #error in adding a field to a report

[Janet T]

I downloaded the Customer Service template in access 2007. I want to add an
existing field (customer's company name) to the Case Details report, and when
I do, it causes #Error in the Comments section. Does anyone know how to fix
this? This code is in the comments field box:
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

 

[KARL DEWEY]

What kind of function is 'ColumnHistory'? I have never run across it before.

 

[Janet T]

It is a column that keeps a running history of your comments. You type your
comments int he comments field and they automatically go to the history
column.

What kind of function is 'ColumnHistory'? I have never run across it before.
--
KARL DEWEY
Build a little - Test a little

I downloaded the Customer Service template in access 2007. I want to add an
existing field (customer's company name) to the Case Details report, and when
I do, it causes #Error in the Comments section. Does anyone know how to fix
this? This code is in the comments field box:
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

 

[Janet T]

I think I need to get my "customer's company name" to the fields available
for the report. Can you tell me how to do that?

What kind of function is 'ColumnHistory'? I have never run across it before.
--
KARL DEWEY
Build a little - Test a little

I downloaded the Customer Service template in access 2007. I want to add an
existing field (customer's company name) to the Case Details report, and when
I do, it causes #Error in the Comments section. Does anyone know how to fix
this? This code is in the comments field box:
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

 

[KARL DEWEY]

Can not help with this.
--
KARL DEWEY
Build a little - Test a little

I think I need to get my "customer's company name" to the fields available
for the report. Can you tell me how to do that?

What kind of function is 'ColumnHistory'? I have never run across it before.
--
KARL DEWEY
Build a little - Test a little

I downloaded the Customer Service template in access 2007. I want to add an
existing field (customer's company name) to the Case Details report, and when
I do, it causes #Error in the Comments section. Does anyone know how to fix
this? This code is in the comments field box:
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))