How do I retrieve history from an append only field in Access 2007

[AprilM]

I have turned on the Append Only feature in Access 2007 so that my notes
field will log its history and I can essentially use my database as a CRM.
Now I want that history information to show up on a report. How do I code
the notes field to make that history show up in a separate table or memo
field with information in descending order (most recent date first) so that I
do not have to right-click the field to see its history? And where do I
place that code?

 

[AprilM]

*Thank you* for the response. I can tell this is exactly what I'm getting at
.. . . it's unfortunately just a bit too high-level for me to grasp how I can
take this information and make it work for me in my database. I'm seeking
more simplified language and, perhaps, a guide that shows me why what code is
where so that I can look into making my own code from a very simplified
"building block" approach, if that makes sense.

 

[AprilM]

Now I'm beginning to see the way this fits together. However, I've now
entered these expressions (where my table name Issues, column name Notes, ID
field Complaint ID):

=ColumnHistory([RecordSource],"Notes","[Complaint ID]=" & Nz([ID],0))
=ColumnHistory([RecordSource], "Notes","Complaint ID"=" & Nz([ID],0))
=ColumnHistory([RecordSource], "[Notes]","[Complaint ID]"=" & Nz([Complaint
ID],0))
=ColumnHistory([RecordSource], "Notes","Complaint ID"=" & Nz([Complaint
ID],0))
=ColumnHistory("Issues","Notes","ID=Complaint ID" = "& Nz([Complaint ID],0))

Each time I try and save the form, Microsoft Access gives me this error
message:
"The expression you entered has an invalid string. A string can be up to
2048 characters long, including opening and closing quotation marks."

Thank you for spelling this out for me, by the way!