Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report in Access
Message
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
01039193
Message ID:
01039642
Views:
26
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform