I have a simple table containing various customer information and 
pricing.  One column contains the customer number.  Each customer may have 
anywhere from one row to fifty rows of data.  In my report, I am listing 
customer data by row and need to help inserting a page break between 
customer numbers.  

For example customer 7100 has 30 rows of data and I am listing each row on 
the report.  The rows create two pages of information.  Once the 
information for customer 7100 stops, customer 7200 starts on the same 
page.  Can anyone tell me how to make customer 7200 start on the next 
page? 

Thanks in advance for any help!

On your report, Customer must be a header (grouping and sorting)
Then on the properties for the header, there is a property called "Force New
Page" - i think this is the one you want.


-----Original Message-----
From: Jennifer Barton [mailto:jennifer.barton@j...]
Sent: 12 March 2003 15:46
To: Access
Subject: [access] Access Report - Page Break Help!


I have a simple table containing various customer information and 
pricing.  One column contains the customer number.  Each customer may have 
anywhere from one row to fifty rows of data.  In my report, I am listing 
customer data by row and need to help inserting a page break between 
customer numbers.  

For example customer 7100 has 30 rows of data and I am listing each row on 
the report.  The rows create two pages of information.  Once the 
information for customer 7100 stops, customer 7200 starts on the same 
page.  Can anyone tell me how to make customer 7200 start on the next 
page? 

Thanks in advance for any help!


_________________________________________________________
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing, 
or copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
_________________________________________________________

Thanks Sarah!  My report is now working just fine!

> On your report, Customer must be a header (grouping and sorting)
Then on the properties for the header, there is a property called "Force 
New
Page" - i think this is the one you want.


-----Original Message-----
From: Jennifer Barton [mailto:jennifer.barton@j...]
Sent: 12 March 2003 15:46
To: Access
Subject: [access] Access Report - Page Break Help!


I have a simple table containing various customer information and 
pricing.  One column contains the customer number.  Each customer may have 
anywhere from one row to fifty rows of data.  In my report, I am listing 
customer data by row and need to help inserting a page break between 
customer numbers.  

For example customer 7100 has 30 rows of data and I am listing each row on 
the report.  The rows create two pages of information.  Once the 
information for customer 7100 stops, customer 7200 starts on the same 
page.  Can anyone tell me how to make customer 7200 start on the next 
page? 

Thanks in advance for any help!


_________________________________________________________
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing, 
or copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
_________________________________________________________

Thank you!  I had my customer number in the wrong header and once I moved
it  and set the Force New Page...it worked.

Whew!

Thank you,

Jennifer Barton
Administrative Assistant
xxx-xxx-xxxx
jennifer.barton@j...
www.jotun.com/us



                                                                                                         
                    "ROBERTS, Sarah"                                                                     
                    <Sarah.ROBERTS@w...        To:     "Access" <access@p...>            
                    a.slb.com>                         cc:     (bcc: Jennifer Barton/MMUS/Jotun)         
                                                       Subject:     [access] RE: Access Report - Page    
                    03/12/03 09:37 AM                  Break Help!                                       
                    Please respond to "Access"                                                           
                                                                                                         
                                                                                                         




On your report, Customer must be a header (grouping and sorting)
Then on the properties for the header, there is a property called "Force
New
Page" - i think this is the one you want.


-----Original Message-----
From: Jennifer Barton [mailto:jennifer.barton@j...]
Sent: 12 March 2003 15:46
To: Access
Subject: [access] Access Report - Page Break Help!


I have a simple table containing various customer information and
pricing.  One column contains the customer number.  Each customer may have
anywhere from one row to fifty rows of data.  In my report, I am listing
customer data by row and need to help inserting a page break between
customer numbers.

For example customer 7100 has 30 rows of data and I am listing each row on
the report.  The rows create two pages of information.  Once the
information for customer 7100 stops, customer 7200 starts on the same
page.  Can anyone tell me how to make customer 7200 start on the next
page?

Thanks in advance for any help!


_________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing,
or copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
_________________________________________________________