Any Access Report Experts??? Please reply!! :-)

[TIDEBED]

I posted this message several days ago and received zero responses. There
doesn't seem to be anyone that I can find who is an Access Report Writing
Whiz. If *you* are, please help me out! Thank You!

??? Report ??? - Page of Pages multipass report

Hi Access Report Writing Experts!

I’m working on a report which uses the Page of Pages functions to display
the Page numbers. Life is wonderful when I select this report to print
within the range of one group (eg. The Order Details for one Customer is 3
pages long, Page 1 of 3, Page 2 of 3, and Page 3 of 3).

Yet, when I select a range of Customers, I would like the report to
renumber for each Customer. See the following:

Cust #1 = 3 pages Page 1 of 3, Page 2 of 3, Page 3 of 3
Cust #2 = 2 pages Page 1 of 2, Page 2 of 2
Cust #3 = 4 pages Page 1 of 4, Page 2 of 4, Page 3 of 4, Page 4 of 4
________
9 pages total

Currently, I get: Page 1 of 9, 2 of 9, 3 of 9, etc,....

I’ve looked at the Access Solutions database, but this topic doesn’t
“seem” to be covered. I’ve already been told that it can’t be done, but I
refuse to believe this. This is a “standard” report writing request. Can
it be handled in the query, should code be written, group bys, ???? If you
have experience with this please help me out.

If you’d prefer, you may e-mail at: wh...@aol.com and I will post a
summary of responses here.

TIA!!!!!!!!!!!!!!! :-)

Deb

[Tom Vehoski]

You may need to do additional queries and print multiple reports to
accomplish this. It will take some code writing. Try the following
procedure:

1. Query your existing query or table and select all of the customer IDs
or names.

2. Count the number of different customers.

3. Start a loop that will move through the query you created in step 1.

4. Read each record in query 1 and use it as criteria for your report
query. This way only one customer will print per report.

5. Continue looping through the customers until you have been through
all of them. Print a report on each pass through the loop.

There may be an easier way, but this works for me. I use this method to
generate several custom reports that automatically get faxed to
suppliers. Suppliers only see THEIR data, not that of other suppliers.

Hope this helps,

Tom Vehoski

[GREG VINCENT]

tid...@aol.com (TIDEBED) wrote:

>TIA!!!!!!!!!!!!!!! :-)

>Deb
>

The MS Access 2.0 Knowledge base article "SAMPLE MACRO TO RESET PAGE
NUMBER ON GROUP LEVEL REPORT" may help you out The article number is:
Q104760. You can download this article from CompuServe or from
Microsoft's FTP site. Below is the summary text for the Knowledge
Base article. If you can't find the article let me know and I can
e-mail it to you?

"It is possible, using macro and report section properties, to design
a
report that breaks the page for each new entry in a group and resets
the report page number. For example, the "List of Products by
Category"
report in the sample database NWIND.MDB could be redesigned to break
the page for each new category and reset the page number to 1."

Greg
----

There cannot be a crisis today; my schedule is already full.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Vincent | CableData
| Greg_V...@USCS.COM