How to stop Detail splitting on Report 1

[TedRSki]

I have a report that prints the employee hours for each day and then sums the hours for the selected period. The Detail section of the report when it reaches the bottom of the report splits with some days on the first page and the rest of the days on the next page. Does anyone know a way to stop this splitting of the detail section? Any help appreciated.

 

[JoanneM]

Hello

there is a property keep with first detail this normally lumps the data onto a page or if its too big for what is left of a page it will start the record on the next page.


As you didn't say which version of Access you are using I can't point you to its exact spot, but it should be in the report properties if memory serves me right


goodluck

jo

 

[TedRSki]

Thank you, Joanne, for your input. I found it on the Report design. Because I am sorting by the Employee name when I went to the Sort filter on the design, there is an "option" to Keep It All on One Page or not. I set it to keep it on one page and it works. Thank you again.