firebirdta84
Technical User
Good Morning,
I've been stumped on this problem for about a week now, hoping someone can help me out.
I have a table called "tbl_Messages", and it contains a message transmitted by a user. Depending on the length of the message, it could all appear in one record, or the message could be split up across multiple records. There is no limit to the number of records associated with a given message, most are 10-15 lines, but can go into the hundreds.Changing the way the data is received is not an option.
Each report number can have one or multiple messages attached to it, and each message sender can send one or multiple messages for a given report number.
The message "pieces" are always sequential, so there's no worry about messages getting jumbled.
The message sequence field indicates the number of lines for a given message. Each time this number resets to "1", that indicates the start of a new message.
I need help writing some VBA code to be used within MS Access 2010, that will read every record in tbl_Messages, and will join the pieces of the message into one complete line under the field "Full Message". If the message is only one line, then it simply copies that one messaged line into the "Full Message" field.
Attached is a sample of what the data looks like coming in, and what I want the outcome to be.
Any help is GREATLY appreciated!
Thanks
Joe
I've been stumped on this problem for about a week now, hoping someone can help me out.
I have a table called "tbl_Messages", and it contains a message transmitted by a user. Depending on the length of the message, it could all appear in one record, or the message could be split up across multiple records. There is no limit to the number of records associated with a given message, most are 10-15 lines, but can go into the hundreds.Changing the way the data is received is not an option.
Each report number can have one or multiple messages attached to it, and each message sender can send one or multiple messages for a given report number.
The message "pieces" are always sequential, so there's no worry about messages getting jumbled.
The message sequence field indicates the number of lines for a given message. Each time this number resets to "1", that indicates the start of a new message.
I need help writing some VBA code to be used within MS Access 2010, that will read every record in tbl_Messages, and will join the pieces of the message into one complete line under the field "Full Message". If the message is only one line, then it simply copies that one messaged line into the "Full Message" field.
Attached is a sample of what the data looks like coming in, and what I want the outcome to be.
Any help is GREATLY appreciated!
Thanks
Joe