Skip to Content
0
Former Member
Jan 29, 2009 at 09:09 PM

Pagnation by the first letter of the last name

32 Views

Hello,

I have a report that is Grouped by Cities and then Last Name. So New York is the city and then all the customers are listed below in Ascending order starting with the first customer who last name begins with the letter A and continues thru to Z and then the next City Starts with it's customers listed A thru Z.

What I need now is to have the report put the customers on a new page when the first letter of the last name changes. So New York will have it's cutomers with last names that start with A on page 1 and end on page 2 and New York customers with last names that start with B will start on page 3 and end on 5 and so on. How do I achieve this?

Thanks,

Heather