Inserting Page Breaks with conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having trouble inserting a page break in an access address list report. I
want a new page to be generated at the change for the first letter of the
last name. For instance, everyone whose last name begins with an "A" is on
page 1 and everyone with a "B" is on page 2 etc... What condition do I use
for my macro?

Please help!

Thanks,
 
On your address list report create a Group Header and Footer set to Group On
prefix charcaters. On the Report select the Group Footer and set it to Force
New Page After Section.
 
Back
Top