CODEWITHSUNDEEP
ms-accessms-access-2007
Nupur
Nupur

Reputation: 357

Is it possible to combine reports in MS access?

I have different reports in Access for different cities. Every city has 8 pages (means 8 different reports).

Is it possible in Access to combine reports (8 pages of a city) together to see all the pages together and not as separate reports?

Upvotes: 0

Views: 5445

Answers (1)

Stephen Turner
Stephen Turner

Reputation: 7314

The easiest way is to put each report as a full page subreport of a new master report.

If you put a hidden control on the master report you can link child and master fields so each subreport shows the same city.

you can even bind the master report to the list of cities so each one shows in sequence.

Upvotes: 2

Related Questions