Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: Combining Multiple Rows Into One

    Recently I made a program to generate and fax/email dunning letters and invoices to past due accounts. The program is working well but I need to add something to update the journal text in our ERP system. I'm pretty baffled with this because I'd need to combine multiple rows into one field so that I would only have one note added per account even if multiple invoices were sent for a single account. For example:

    From:
    Tablename:"Invoices Temp Log"
    "Acct" "Invoice #"
    4190 I400000
    4190 I400005
    4190 I400008
    V220 I400003
    V220 I400004
    888 I400001

    To:
    Tablename:"Notes For Diary Text"
    "Acct" "Invoice #"
    4190 I400000, I400005, I400008
    V220 I400003, I400004
    888 I400001

    How in the world would I do this? Oh, yeah, and I am definitely a newbie with VB so if I need to go that route, I might need some extra grace. Thanks! JB

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Paul

  3. #3
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Quote Originally Posted by pbaldy
    I don't know if that could be changed easily for my program. The problem being that I need to have text concatenated and not numbers. I wish I knew the VB side better, I know it can be changed, I'm just kind of a newbie to VB code. I appreciate the help though! Joshua

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Did you look at it? It is built into it to be able to handle text primary keys (it's one of the arguments passed to the function), and the type of value being concatenated doesn't matter. Post a sample db of your data if you're still stuck.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •