Creating a sequence of numbers totaling a specified number

[kquackenbush]

Hi,

Fairly new to Access, so will take all the help I can get on this one...

I am trying to create a mailing form that I can enter a total number of mail pieces into that will divide the total number of pieces into bundles of 100 and create the correct amount of forms.

E.g.

If there are 587 pieces of mail, there will be a total of 6 bundles (5 bundles of 100, 1 loose bundle of 87).

1) How can I create a sequence that would equal the total number of bundles, in this example 6, to go in the field highlighted by the red box, so that it creates 6 total pages when I go to print?
i.e. 1 of 6, 2 of 6, 3 of 6, etc.


2) I also need to display how many total pieces are in each of the bundles. How can I display bundles 1-5 with 100 mail pieces and bundle 6 with the remaining 87?

Thanks!

[Micron]

Wondering if this is more related to the reports forum rather than forms because running calculations are easier in reports. Regardless, you could use the Mod function, as in
587 Mod 100 to return the remainder (87), and round down 587/100 to get 5 bundles: Int(587/100) = 5
Not enough info to say how to get those values in to what.