Creating CSV export file based on record grouping

[jaxmax]

Please help!

I'm trying to create a csv export file to import into another app, and am horribly stuck. The usual export function works fine for single line records, but when there are multiple lines within the same record (in this instance, I'm trying to export invoice details) it all turns to custard!

How do I select values to group on in VB mode, and then collect all the records within the range to list as subsequent strings, rather than new records?

 

[bat17]

I am not sure that this is quiet what you are after but have you tried creating your invoice in a report and exporting that as a text file?

Peter

 

[klb]

Have you tried selecting the information that you want in a query and then exporting the query results to the csv file?