A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

section breaks in reports



 
 
Thread Tools Display Modes
  #1  
Old March 21st, 2005, 11:53 PM
tvt
external usenet poster
 
Posts: n/a
Default section breaks in reports

Hi,

How do i format my report so that a section will not be split between two
pages of a report? For example:

Report 1 looks like this:

Location 1
tenant 1
tenant 2

Location 2
tenant 3
tenant 4
.....

How do i format the report so that all tenants of Location 2 are on the same
page and are not split between two pages . Something like an auto section
break?! Thanks!
  #2  
Old March 22nd, 2005, 12:31 AM
Ken Hudson
external usenet poster
 
Posts: n/a
Default

Open the report in design view. Open the Sorting and Grouping box. In the
"Keep Together" box select "Whole Group."

Regards.

"tvt" wrote:

Hi,

How do i format my report so that a section will not be split between two
pages of a report? For example:

Report 1 looks like this:

Location 1
tenant 1
tenant 2

Location 2
tenant 3
tenant 4
.....

How do i format the report so that all tenants of Location 2 are on the same
page and are not split between two pages . Something like an auto section
break?! Thanks!

  #3  
Old November 22nd, 2005, 11:08 AM
masterkeys masterkeys is offline
Member
 
First recorded activity by OfficeFrustration: Nov 2005
Posts: 13
Question

I've got a problem very similar to this, but I need to print each section seperatly, even if two complete sections fit on 1 page.

Any ideas how to achieve this?

any help greatly appreciated.

office n00b
__________________
Da mihi sis bubulae frustrum assae, solana tuberosa in modo gallico fricta, ac quassum lactatum coagulatum crassum

Give me a hamburger, french fries, and a thick shake

Last edited by masterkeys : November 22nd, 2005 at 12:53 PM.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
`Continued...` in reports inside/under Details section Babbage Setting Up & Running Reports 0 November 8th, 2004 02:48 PM
section breaks, orientation and margins Michel Offringa Page Layout 7 June 15th, 2004 04:18 PM
Section Breaks Brand33 Worksheet Functions 2 February 9th, 2004 04:33 PM


All times are GMT +1. The time now is 08:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.