Access Report

[mercwonder007]

I have a report that I am running and it consists of multiple records grouped by a company name. I need to have 1 company per page. I tried entering in a page break but that puts all the clients under the group on thier own page. In other words lets assume I have 3 companies with 5 clients per company. I need to then have each company on a separate sheet (ie: 3 sheets). Any help with this would be awesome. Thank you so much.

 

[vivasuzi]

This is fairly simple. I hope I explain it right! If not, just ask questions and I'll clear it up. I have two options for you to do this, both similar, try them out!

OPTION 1:

In Design view, open up the Sorting and Grouping. (View Menu --> Sorting and Grouping)

You should see your company group on the list. Make sure "Group Header" is set to Yes.

You can close that box now.

Now right-click on the "Company" header (the gray bar) and choose properties.

Under the "Format" tab you'll see "Force New Page" Set this to "Before Section"

This will have the effect of putting a Page Break BEFORE every company. This might result in a blank page at the start unless you have a report header. If you don't like this, try OPTION 2.
-------------------------
OPTION 2:
In Design view, open up the Sorting and Grouping. (View Menu --> Sorting and Grouping)

You should see your company group first. Make sure "Group Footer" is set to Yes.

You can close that box now.

Now right-click on the "Company" footer (the gray bar) and choose properties.

Under the "Format" tab you'll see "Force New Page" Set this to "After Section"

This will have the effect of putting a Page Break AFTER every company, however if you have a report header it will probably still show on the first companies page.

----

Depending on your data, these might give the same results. Hope this helps!

*Suzanne*

http://www.vivasuzi.com