I need to concatenate values from the same field in Access to read as one long string.
For every account, our staff enters notes in our system and those notes are saved for posterity on a sql server that is the source of my query.
I need to the most recent note entered by specific staff members for specific account numbers.
Each note can consist of multiple lines in our system. This is what a single note looks like when entered in our system by employee 07676:
And each line is stored as an individual record on the server. Here is the same note , as stored on our sql server:
One note entered, three lines, three record in the same field that I need concatenated .
Every note entered by the same person, on the same day,for same account, is assigned a [NoteSequence] number which is the field the above three records have in common (in addtion to the account number, employee id, date).
I need to concatenate the values in the [NoteMessage] field where [NoteSequence]=[NoteSequen
ce] order by [TransactionSequence]
I need to turn this :
Borrower Intent - Keep Property
RFD006 - Curtailment of Income
IB-Inbound .Borrower Intent - Keep Property. RFD006 - Curtailment of Income
TransactionSequence is the order of each line item/record.
NoteSequence is the number assigned to each note made by the same employee on any given day, on the same account.
07676 actually made 3 notes on that day consisting of 9 lines.
As it appears in ours system, order by NoteSequence 3, 2, 1
Each note entered may consist of multiple lines. The above shows 3 different notes entered on the same day by employee 07676. The newest note is on top consists of three lines.