New Page Per Postcode Area 1

[EvilTwinOfAtrus]

Hi

I have a simple report which is grouped by Postcode area (Fieldname - Postcode1) (NG1, LN1) etc and under each postcode, lists the people who live there (Fieldname - NameFull).

What I get at the moment is a report which overlaps postcodes - ie a few of the people from NG2 are on the NG1 page as the current page starts off with NG1. What I want to do is force a new page, everytime the next postcode area arises.

Thankyou,
EToA

 

[dhookom]

Use the Force New Page of the group header or footer section. You can also add a Page Break control to the very bottom of a Group Footer.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[EvilTwinOfAtrus]

What sort of stuff would I need to put in the Page Break control?

- EToA

 

[dhookom]

It is the page break control found in the tool box.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.