Would you please tell me is there a way using VBA code and queries to get data from one table and contantenate in another table in following way:
Loan No Comments
123456 Hi Peter
123456 Hi Martin
123456 Hi Nick
I need to put Comments in following way: "Hi Peter; Hi Martin; Hi Nick"
As you understand actual data is different. Loan have multiple comments sometimes up to 4 or 5 records.
I need to contantenate all comments into one record (which has memo data type)
All these code will be run from the command button of the form.
I was asking this questions before however experts could not help me.