Want to add a page break in an access report after critera is met

[Guest]

I have a report in our contacts database which lists the organisations held
in our database, followed by the indervidual staff contacts for that
organisation. I can put in a page break which seperates each entry, but I
want the page break to go in after all the staff for that organisation has
been listed. I therefore guess I need to build an event procedure statement,
but have no idea what to actually write. Can anyone help?

 

[Boyd \Hi Tech Coach\ via AccessMonster.com]

Actually this is a built in property setting in an Access report to handle
what you want.

In the group footer, set the "Force new page" property to "after section"

 

[Guest]

I didn't actually set up the report, and don't really know how it was set up,
but unfortunatley it isn't actually grouped, so there is no group footer.
Thanks for your suggestion though.

 

[PC Datasheet]

The solution starts with the design of your tables. You have a one-to-many
relationship between Organizations and Contacts. Therefore, you need the
following tables:
TblOrganization
OrganizationID
OrganizationName
etc

TblContact
ContactID
OrganizationID
FName
MI
LName
etc

Your report then should be built as a report/subreport. The main report
should be based on TblOrganization and the subreport should be based on
TblContact. Your report then would have the Organization fields in the
detail section with a subreport control directly below the last field. The
subreport source object would be the subreport. You would then put a
pagebreak under the subreport control.