Search results

  1. I

    Concatenate Column Values from Multiple Rows into a Single Column

    Ok, Bettle, I think I've got it figured out. The VBA can only look for data on the same table. I realized I was trying to push linked data from another table, hence the errors. The suggestion you had works with the link, but breaks concatenation. This is what worked (for me at least). I...
  2. I

    Concatenate Column Values from Multiple Rows into a Single Column

    Hey Beetle - Thanks for the reply. That does get me some of the way there, but it seems to break the concat. The return I'm getting has names, but is structured as: VerID ApproverIDs 59 Joe 59 Bob 59 Jim 144 Brad 144 John As opposed...
  3. I

    Concatenate Column Values from Multiple Rows into a Single Column

    Hi Everyone, This has been a great thread and is getting me oh so close. Wondering if anyone had some insight they could share. I'm nearly there, but can't seem to get what I need from a linked table to change my numerical DB key into the text that's associated with it. I've setup a module...
Back
Top Bottom