VB Code for Access

[PritiOne]

I was wondering if anyone could help me write a code that would help me format my footers on an access report.

Based on the value of a field (Sales Associate Name) I need the report footer to have page 1 - (whatever), but start at 1 again when the name of the Sales Associate has changed.

Basically - can I re-start my page counter when the value of the field changes? Thanks for any help - hope this is clear.

Priti

 

[PritiOne]

Can anyone out there think of anything? If it can't be done - that information would be helpfull too.

Thanks!

 

[Philem]

Hullo! In A97, try looking at the ForceNewPage property. Unfortunately, no clue about other versions.

HTH

P

 

[CT Witter]

Try MS KB article #209215- How to reset the page number on a group level in an Access report
http://support.microsoft.com/default.aspx?scid=kb;en-us;209215&Product=acc

or

#306127 -
ACC97: How to Reset the Page Number and Total Page Count for Each Section of a Report http://support.microsoft.com/default.aspx?scid=kb;en-us;306127&Product=acc

HTH

 

[PritiOne]

THANK YOU! :wink: