Re-start page numbers in each new group

[Dana W. Ciardi]

I have a report grouped to show claims for each individual hospital. I have
each group printing on a separate page. In the Group Header (Name of
Hospital), I have Page x of x pages. My problem is that the numbers are
cumulative from 1 through 12. I want the page numbers to run from 1 - 3 for
the first hospital, then 1 - 2 for the second hospital, then 1 - 4 for the
third hospital, etc.

Help says to do a macro??? I am a BRAND NEW USER of Access - and don't have
a clue how to do a macro to accomplish the above.

Can someone help me in very elementary terms???

Thanks!

Dana

 

[Guest]

Using macros actually is the easiest way to accomplish this. The other
option would be to write it in code and if you are new, you might not want to
go there. I have looked at the microsoft document regarding this and I will
try to simplify it for you.

First, in your database, click on the macros tab and pick new. On the first
row of the Action column put SetValue. After tabbing you will see that down
below you now have two lines one Item and one Expression. On the Item line
put [Page] including the brackets. On the Expression line put a zero. Save
as mcoPageReset.

Now, in your report design, right click on your group header (the entire
gray bar) and pick Properties. Look for the property called ForceNewPage and
change to BeforeSection. Now, go to the group footer properties and on the
line OnFormat pick the macro above from the drop down.

Hope this works for you. Let us know if you have any trouble.
Jackie )

 

[Dana W. Ciardi]

WOW - that was easy enough!! I guess "Fear of the unknown" is the biggest
fear!!

And it works!!

THANKS!!

Using macros actually is the easiest way to accomplish this. The other
option would be to write it in code and if you are new, you might not want
to
go there. I have looked at the microsoft document regarding this and I
will
try to simplify it for you.

First, in your database, click on the macros tab and pick new. On the
first
row of the Action column put SetValue. After tabbing you will see that
down
below you now have two lines one Item and one Expression. On the Item
line
put [Page] including the brackets. On the Expression line put a zero.
Save
as mcoPageReset.

Now, in your report design, right click on your group header (the entire
gray bar) and pick Properties. Look for the property called ForceNewPage
and
change to BeforeSection. Now, go to the group footer properties and on
the
line OnFormat pick the macro above from the drop down.

Hope this works for you. Let us know if you have any trouble.
Jackie )

I have a report grouped to show claims for each individual hospital. I
have
each group printing on a separate page. In the Group Header (Name of
Hospital), I have Page x of x pages. My problem is that the numbers are
cumulative from 1 through 12. I want the page numbers to run from 1 - 3
for
the first hospital, then 1 - 2 for the second hospital, then 1 - 4 for
the
third hospital, etc.

Help says to do a macro??? I am a BRAND NEW USER of Access - and don't
have
a clue how to do a macro to accomplish the above.

Can someone help me in very elementary terms???

Thanks!

Dana