Hello all, I'm new to the forum and have a question on a .txt file I'm trying to generate. I have developed a database for tracking transactions. Basically, I take all of the transactions at the end of the day and sum them to see if any meet a preexisting threshold. If they do they need to go on a report that will be exported to a .txt file. Now for my issue...
I have everything layed out in the report, many many concats which result in very long strings. My issue is, this thing cuts off when i export to .txt. Is there a way around this? Also, if not would it be possible to write some vba to make it export properly? Thanks for any help in advance.