Hello,
I have a field called "Additional Comments" in a table/form that I would like all responses to populate in a report field. I have tried using "=[Additional Comments]" and only one comment is populated in the report field. But I need all of the comments appended and populated in the field, preferably separated on different lines. I have tried using "=ColumnHistory([Table Name], [Additional Comments], [?]) But I am not sure what to use for the query string so the command is resulting with an error. Is there an easy way to populate the report field with all Additional Comments to a table/form? Preferably without a query if possible?
Thank you