View Single Post
 
Old 02-08-2012, 10:17 PM
Emaleth9999 Emaleth9999 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 1
Emaleth9999 is on a distinguished road
Default Force a page break

Hi - can someone please tell me how to get this to force a page break after each change in last name.

Code:
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record If»


Page 2 should start with Anton
Results Page 2
ALMAGUER CA-AA494 ASPE100e First Time Adoption (CICA 1500): Canada Not Enrolled
ALMAGUER CA-AA526 ASPE101e Financial Instruments - Recognition, Measurement and Impairment (CICA 3856): Canada Not Enrolled
ALMAGUER CA-AA527 ASPE102e Financial Instruments - Hedging and Derivatives (CICA 3856): Canada Not Enrolled
ALMAGUER CA-AA528 ASPE103e Goodwill and Intangible Assets (CICA 3064): Canada Not Enrolled
ALMAGUER CA-AA529 ASPE104e Stock-based Compensation (CICA 3870): Canada Not Enrolled
ALMAGUER CA-AA530 ASPE105e Employee Future Benefits (CICA 3461): Canada Not Enrolled
ALMAGUER CA-AA531 ASPE106e Asset Retirement Obligations (CICA 3110): Canada Not Enrolled
ALMAGUER CA-AA533 ASPE107e Disclosure under ASPE: Canada Not Enrolled
ALMAGUER CA-AA503 ASPE110 Cdn GAAP to ASPE Transition Workshop: Canada Not Enrolled
ANTONCA-AA494ASPE100e First Time Adoption (CICA 1500): CanadaNot Enrolled

Each page decreases Almaguer by one and adds Anton - I would like all of Almaguer on one page, all of Anton on the next and so on....

I'm using { NEXTIF { MERGEFIELD LAST_NAME } = ''''}

Thanks ~ E
Reply With Quote