Multiple reports in a report

[Guest]

Hello:
I'm trying to create a report that shows the customer's mailing address on
the first page, page numbers are "1 of X", account activity is sorted by
[start date] to [end date]. I can do this easily for a single customer. But
when I run a range of account numbers I run into trouble. The first
customer's address appears on the first page, but subsequent addresses don't
appear at all. Page numbers are 1 of 324, etc. Access is running a single
report for a hundred customers - but what I want is 100 seperate reports,
each with unique headers and footers.
Any suggestions?
Thanks

 

[Douglas J. Steele]

Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access Web"

 

[Guest]

Thanks a lot! This solves part of the problem. Any thoughts on displaying
the mailing address on the 1st page of each group?
MC

Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello:
I'm trying to create a report that shows the customer's mailing address on
the first page, page numbers are "1 of X", account activity is sorted by
[start date] to [end date]. I can do this easily for a single customer.
But
when I run a range of account numbers I run into trouble. The first
customer's address appears on the first page, but subsequent addresses
don't
appear at all. Page numbers are 1 of 324, etc. Access is running a
single
report for a hundred customers - but what I want is 100 seperate reports,
each with unique headers and footers.
Any suggestions?
Thanks

 

[Douglas J. Steele]

Ensure that the report's RecordSource includes the mailing address, and
print it in the appropriate GroupHeader.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks a lot! This solves part of the problem. Any thoughts on
displaying
the mailing address on the 1st page of each group?
MC

Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello:
I'm trying to create a report that shows the customer's mailing address
on
the first page, page numbers are "1 of X", account activity is sorted
by
[start date] to [end date]. I can do this easily for a single
customer.
But
when I run a range of account numbers I run into trouble. The first
customer's address appears on the first page, but subsequent addresses
don't
appear at all. Page numbers are 1 of 324, etc. Access is running a
single
report for a hundred customers - but what I want is 100 seperate
reports,
each with unique headers and footers.
Any suggestions?
Thanks