Printing an Array at End of Report

[EddieN1]

I have a report that lists a General Ledger Account and Amount in the Report Detail Section. I can use the On Print events to accumulate these as the report runs. At the end of the report, I would like to list each Account and the Total Amount for each Account in Account number sequence. I don't know in advance how many accounts will need to be listed... might be less than 10 or it might be over 50. How can I show these accounts and amounts in the Report Footer? Thanks, Eddie

[pbaldy]

I'd lean towards a subreport based on a totals query.

[EddieN1]

Here's what I have done and it worked. I defined a Text Box that "can grow" and then formatted each line with a "vbCrLf" between each line. Now I need to work on the formatting, but that will be the subject of another post. Thanks for your help. Eddie

[pbaldy]

Sounds like the hard way, but glad it works for you.

[EddieN1]

pbaldy, thanks for your response. In order to solve the formatting problem, I changed the one text box to three, one for each column. The first was text, align left. The next two were Format Standard, align right. Thanks again, Eddie