CODEWITHSUNDEEP
sqlms-accessreport
KaliMa
KaliMa

Reputation: 2060

How to make a MS Acess Report where you have one page per record?

I cannot figure this out for the life of me.

I want a report object where each page (no matter how big, small, etc) corresponds to one record in the underlying source query (each record corresponds to a Client along with some financial data).

I've tried grouping by Client, inserting page breaks, trying to integrate forms, etc. Nothing. Everything just combines together into one giant list -- there's no separation per page.

Upvotes: 0

Views: 683

Answers (1)

SeraM
SeraM

Reputation: 487

Select the Group Header and view Properties (F4). It should be named something like GroupHeader0. For the Force New Page attribute, select Before Section, After Section, or Before & After Section.

The hardest part of this for me was finding the correct item to click that has the Force New Page attribute -- it isn't the field itself, but the Section (which is named "GroupHeaderX" by default).

Upvotes: 1

Related Questions