470,593 Members | 2,509 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,593 developers. It's quick & easy.

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

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
2 2257
759 512MB
Take a look to post #7 in this thread.
Maybe will be a help you.
Apr 9 '12 #2
32,298 Expert Mod 16PB
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.

Similar topics

3 posts views Thread by bhaalsen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.