Detail and Footer Section

[Administrator]

I have a report with a "Games Header" and a "Games Footer". In the detail
section, I list all invoices for that particular Games Operator. I would
like in the "Games Footer" section to list up to 3 games that operator has.
However, when I place my control "GamesNo" in the footer, I only get one
game instead of the 3 that the operator has. If I try to list the games in
the detail section, it will list one invoice, then one game, then page and
list the next invoice and next game.

How do I get it to list all three games in the footer?

 

[Steve Schapel]

Administrator,

I think you will have to make a separate report for the Games, and put
this as a subreport into the footer of your existing report.

- Steve Schapel, Microsoft Access MVP