Insert Sum/Count info into text file

[lsroka]

I've used the transfertext method to create a delimited text file based on a query. It's a text file of bank batch information. At the top of the text file (just like a report header) I have to insert the Batch ID, then (like a group header) I insert the Deposit ID for each deposit ID group with the records below. At the end of the deposit records (group footer)for that deposit group, I have to insert the total of deposit items and total amount for that deposit group. At the end of the text file (report footer), I have to insert the grand total number of items and amounts for the entire batch.

Any idea how to do these one line inserts into a text file that's based on a query? Is it a crosstab linked to the original query.