Count next record in report summary for different fields

  • Thread starter Thread starter Eric B.
  • Start date Start date
E

Eric B.

I have 30 clients with many records. The report is sorted
by client then by 4 types of transactions (buy, sell,
credit, return).

How can I count to the next client by using 30 different
fields in the report footer (not page or client footer)
thereby, giving summary information, on each individual
client, in report footer.

i.e.
(Report Footer)

field1:
controlsource=[client]

field2:
controlsource= Next([client]+1)

field3:
controlsource= Next([client]+2)
 
It's difficult to understand exactly what you want. I think you need to
create a totals query with your computed values and then use this as a
record source of subreport in your main report's footer.
 
Back
Top