I am using Microsoft Access to move data from one application to another. Part of what I need to do is gather fields (from quotes by our sales department) and put them into a memo field of another program. The fields would be Partnumber, Quantity,and Price Quoted. I can easily build a string for a single item on a quote, but what I can’t do is add additional items if the quote contains more than one item. Also, if possible, I would like to format the memo field so that each item is below the previous, to keep from just having scrambled strings of information. I would really appreciate the help.
