Keeping sections on one page

[ronniepurpleuk]

Hi All,

I'm not terribly Access-savvy yet...

I have created a report which calculates the profit we have made on labour on our jobs, along with invoice details and actual hours worked.

Eg.
Job No.1, Customer Smith
Invoice No. 123, Total Value £300.00, Labour Charged £180.00
Hours Worked
1/9/06 - 4
2/9/06 - 2
Total hours - 6 Labour Cost £60.00
Profit - £120.00

...and then it lists the details of Job 2, Job 3 etc. Obviously, it's set out a bit better than above!

I want to be able to list several jobs on each page but the problem I have is that it cuts the bottom job off onto the next page so I have to turn the page to see all the details which can make things difficult.

Eg.
Job No.1, Customer Smith
Invoice No. 123, Total Value £300.00, Labour Charged £180.00
Hours Worked

...next page...

1/9/06 - 4
2/9/06 - 2
Total hours - 6 Labour Cost £60.00
Profit - £120.00

I can create a page break so that each job is listed on a separate page but this uses 4 times as much paper as I want to use. Is there a way (I assume there must be) to create a break so that when one job won't fit on the page, it starts it on the next page?

Thanks in advance

Ronnie

 

[edtab]

Try this:

- In design view, right click on the report
- Select "Sorting & Grouping"
- Set the "Keep Together" to "No"

I think this will solve your problem.

 

[ronniepurpleuk]

They're set to that already.

Just in case of any misunderstanding, I don't mean that it's splitting up the details on every record. It's just where the last one doesn't fit on the page, it continues onto the next page whereas I would like it to insert a page break so that it moves the details of the last job onto the next page.

Ronnie

 

[ronniepurpleuk]

I've done it - thanks edtab for leading me to the right area!

I changed "Keep Together" to "By Group" and this has worked.

Thanks again - learning more every day.

Ronnie