Grouping Data

[witney]

Hi,

I have trying to create report where the information is grouped on one field. I then want the report to start a new page for each group of information.

However, when I right click the Group Header and select "Force New Page Before Section", Access puts in a blank page before it starts displaying the data.

How do I get rid of this blank page? I have tried to change the force new page to "After Section", but the result isn't what I want. I have also tried changing the properties for the other headers in the report but this doesn't resolve the problem.

Any help would be appreciated.

Thanks

 

[David R]

I tried this for a while as well and wasn't too happy with the results. "Force New Page After Section" was the best I came up with, but I eventually ditched it.

David R


[This message has been edited by David R (edited 03-06-2002).]

 

[Rich]

Did you set can shrink to yes?