"first page number"

[Guest]

Can I set a "first page number" for an Access report? More generally, I have
several different Access reports which I am going to combine into one long
report for my clients. Is there a way to get all the pages numbered
sequentially rather than starting back at 1 on each separate report?

 

[Marshall Barton]

Can I set a "first page number" for an Access report? More generally, I have
several different Access reports which I am going to combine into one long
report for my clients. Is there a way to get all the pages numbered
sequentially rather than starting back at 1 on each separate report?

If at all possible, this should be done by creating a new,
unbound report and adding all the other reports as
subreports.

If that isn't possible, you'll have to use code in each
report to save it's Pages value so the next report can
retrieve it and set the value of Page.

 

[Guest]

Thanks for the tip. I haven't used subreports before, so that'll be fun to
check out how to do that.

 

[Marshall Barton]

You will probably run into the differences between running
separate reports and using those same report's as
subreports, so come on back if you need help with it.

The most common difference is that subreports do not have
Page related events or header/footer sections. This issue
can be worked around in most cases, but will probably depend
on the specifics of your situation.