Count to next to give summary in report footer

[Steve C.]

I have asked this question before but still don't know if
this is possible to do...

I have a report with several clients and each client with
many detailed records bound to a query. The query lists
50 clients with have multiple transactions I want to give
a summary in the REPORT FOOTER for each client.
Therefore, I need to list each clients name in the report
footer by counting down to the next client in the query.
In other words...

Report Footer
+++++++++++++++++++SUMMARY++++++++++++++++++
field1 field2
=[client] A =sum[revenue] for client A

field3 field4
=next [client] B =sum[revenue] for client B

field5 field6
=next [client] C =sum{revenue] for client C

Each client is followed by summary fields related
directly to that client only so, I need to 'next loop'
the data fields as well for the report footer. Is this
possible to do?
Thanks so much for the help.
SC

 

[Duane Hookom]

Create a totals query with the calculated sums of revenue by client. Then
create a report based on this query. Place the new report as a subreport in
the footer of the main report .