Microsoft Access Query To Combine Text

Hello.
I need to use a query to combine text strings from a table based on an order id, and a line number sequence. The line sequence will always be in order, but will not start 1, 2, 3..... The first string is independent of the others. The remaining strings need to be combined into one memo field. Here is a sample of the data.

Ord_No      Cmt_Seq_No      Cmt

00332514      3      Happy Anniversary                      
00332514      4      Brit and Herb, For your Anniversary. We
00332514      5      hope you get to use this frequently. Now
00332514      6       come visit your ill mother. Love Mom an
00332514      7      d Dad                                  
00332515      9      Merry Christmas                        
00332515      10      Merry Christmas Michael, for all your tr
00332515      11      avels.  love MOM  

Is this possible?>
Thank you!
chantalcookwareAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
0
Jeffrey CoachmanMIS LiasonCommented:
Note that in your text, some words are continued on the next record, so it will be tricky to know when it breaks in the middle of a word... (to insert the space-bar delimiter or not)

...so these odd cases will probably have to be handled manually
0
Jeffrey CoachmanMIS LiasonCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

chantalcookwareAuthor Commented:
Having trouble opening the mdb's. Can you post query logic to add to a new table memo field?
0
Jeffrey CoachmanMIS LiasonCommented:
<Having trouble opening the mdb's. >
Please clarify...

<Can you post query logic to add to a new table memo field? >
That info (and the query used/needed)  is in the link I posted, ...it is a simple INSERT query...
0
chantalcookwareAuthor Commented:
Tells me file is untrusted. I will look around for workaround to open it.
0
chantalcookwareAuthor Commented:
I got it open and test db works. Can the ord_no field be text? I can't make it work with the text ord_no field.
Thank you again.
0
Jeffrey CoachmanMIS LiasonCommented:
Lets back up...

Did the sample I posted work for you?
Yes or No?
0
chantalcookwareAuthor Commented:
Yes, it works with an additional autonumber field, and a numeric order number field. Thank you.
0
Jeffrey CoachmanMIS LiasonCommented:
Change the query to this:

SELECT YourTable.Ord_No, DConCat("cmt","YourTable","Ord_No = " & "'" & [Ord_No] & "'"," "," ",False) AS Combined
FROM YourTable
GROUP BY YourTable.Ord_No, DConCat("cmt","YourTable","Ord_No = " & "'" & [Ord_No] & "'"," "," ",False);
0
chantalcookwareAuthor Commented:
Thanks. I was able to do some other tweaks and make your original code work.
0
Jeffrey CoachmanMIS LiasonCommented:
great

;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.