By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Concatenating multiple rows of a field to a single field in another table

P: 1
I have a Table(PA Phrases) consisting of phrases to be used in a purchase agreement, but not all phrases apply for every purchase agreement. I want to allow the sales rep to select the phrases desired from a form, and then have a VBA or access query take all the phrases and concatenate them into a single paragraph style string, and put that string into another field in another table or at least into a text box on the form. I need to know what commands to use in VBA to pull from the PA phrases table and how to write to another Table or text box. I plan to use a count loop to search my PA phrases table and only pull from rows with a "yes" in the checked field, but I just don't know vba to pull the table in and write it out. once i link it in vba, i believe i can get the rest working.
Apr 8 '12 #1
Share this Question
Share on Google+
2 Replies


100+
P: 759
Take a look to post #7 in this thread.
Maybe will be a help you.
Apr 9 '12 #2

NeoPa
Expert Mod 15k+
P: 31,409
Check out Combining Rows-Opposite of Union for a discussion of some of the issues and some sample code to get you going with.
Apr 11 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.