>Naomi,
>
>Could you please explain a bit more.... The header looks like this, no?
>
>
>Page 1 of 100 Ank - Bertolli New York
>.
>.
>.
>Page 30 of 100 ampersand - burro Other States & Cities
>.
>.
>.
>
>Are you keeping the groups together by page?
Hi Ric,
I actually just remembered, that I don't print total number of pages, though it doesn't make a difference.
The page header looks like:
Aminov Page 1 Babanov
New York
Then the first page in that group (all customers in NY have SortOrder = 1)
New York
Then I have State Group
New York
In other words, I repeat New York 3 times on the first page of my report, since I print in the Page Header, in the SortOrder group and in the State group headers.
I don't start a new page, when State changes, so I can have two states on the same page. I do start with a new page when I change SortOrder.
If you don't mind, I can send you Access database with the report by e-mail. I don't remember, how big it is. It's at home. If you don't mind, please, send me a letter to nnosonovsky at gmail dot com so I can reply and send you the database. Or I can send you a PDF.
Thanks a lot for helping me.
If it's not broken, fix it until it is.
My Blog