Access Assistance please?

[Extra 300 Driver]

I am trying to teach myself access, and I am doing ok but I have now become stuck and frustrated.

Imagine I am reporting sales per person per week. The weeks, sales people, target sales and actual sales are all in different columns. When I run the report it comes out really well, having info in different columns allows me to have different font to highlight the weeks.

The problem I am having is that on the report I get part of a weeks results on one page and the remainder on the following page. What I would really like is to have a page break should that week not fit on the remainder of the page, or have all the weeks ping on separate pages.

I have 355 lines of info in 6 columns,

Any help greatly appreciated,

[5pen]

It's a bit difficult without seeing your actual report, but are you using a group header for the weeks? If so I'd suggest you have a play with the following options...

Both the group header and footer have a property that can be set to force a new page before, after or before & after that section. There is also a 'Keep Together' property which will do it best depending on the number of rows in the section to keep it all on one page.