Page breaks in a report

[kavarin]

I have a report (based on a query) that generates status/sales reoprt. We use various descriptions in our status field and the report shows all records so we can see where our files stand in our process. Is it possible to have the report page break between each of the different status types?
Example:
All CLOSED files are on the first page....IN PROCESS files are on the second...so on and so forth?

 

[Runutts]

When your in design view on your report just click the page break symbol on the tool box and drag it to where you want the page break to be, if your in details it will reprint the header on the next page.

 

[kavarin]

But will that also separate the data? I am looking to have it create separate pages for each different value??

 

[Pat Hartman]

In the form's sorting and grouping properties dialog, specify that you want to sort by status and that you want a group header and footer. In the footer, you can put Count(*) and Sum(SomeField) functions to do any totalling that you need. Then in the properties for the group header, you can select the page break option. The header section doesn't actually need to contain any fields unless you want it to and you only need the group footer if you need to do any totalling.

 

[kavarin]

Thank you so much Pat

I will try that appraoch and post again if I run into problems