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:
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
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.