Creating multiple-page reports in Access (new page for each group)

ms-access report ms-access-2013
ThePGtipsy picture ThePGtipsy · Dec 7, 2013 · Viewed 14.3k times · Source

I'm looking to create a report which is specifically designed to be over multiple pages, based on one condition. The condition is that when the grouped item (call it invoice) changes, it starts a new page, instead of putting all the data on as little pages as possible.

At the moment it runs like this,

Invoice, Date, ID
------------------
2      , Now , 1
------------------
3      , Now , 1
------------------

I want to insert a page break between the invoice numbers, but can't figure how to do it, is it possible?

Answer

Gord Thompson picture Gord Thompson · Dec 7, 2013

In the Group Header for "Invoice" on your report you can set the Force New Page property to Before Section to start each invoice on a new page. For details, see

Print each group of your Access report on a separate page

Related questions

How can I output a report in PDF format, where the name consists of values from fields?

I want to add functionality to my Access 2007 report whereby a PDF copy of the report is created at the click of a button. I know that there is an OutputTo macro which can do this for me, but it …

Read More
CountIf formula within MS Access report

Something terrible as happened with my poor attempt at adding a CountIf forumula to my access report. I am trying to add a formula within my report header to count the number of entries in my Service column that contain …

Read More
MS Access 2003 - Opening a report without it printing

I used Docmd.OpenReport "Report1" from another form and it seems to just want to print the report without actually displaying it. I want to display the report, not print it

Read More