Hello
I am trying to create a query that will add additional text to an existing Long Text.
Ex: tblMasterAcctList
I would like to add a note to specific accounts that states "Interest paid" without replacing the existing note.
ID (auto) AcctNumber (long) Note (long) 1 34T45 existing client 2 12RE4 new acct 3 7RT56 existing client 4 89456 inheritance
That data is in the following table:
tblNoteAppend
AcctNumber (Long) Note 34T45 Interest Paid 7RT56 Interest Paid
The outcome I would like is:
ID (auto) AcctNumber (long) Note (long) 1 34T45 existing client; Interest Paid 2 12RE4 new acct 3 7RT56 existing client; Interest Paid 4 89456 inheritance
Current query reads:
INSERT INTO tblMasterAcctList ( Notes )SELECT tblNoteAppend.note
FROM tblMasterAcctList INNER JOIN tblNoteAppend ON tblMasterAcctList.AccntNumber = tblNoteAppend.acctnumber;
Obviously doesn't work. Getting 'Validation Rule Violation' and based on my understanding of how append queries work, it's not really even trying to do what I want it to do anyway. I feel like the Append Query is a red herring and there is a different way to append data within a field.
Any help greatly appreciated. There are about 500 records to be updated and this is a recurring event, so I'd like to find a way to do it programmatically rather than cut/paste 500 times every 6 weeks.
Thanks
Steve