divide records evenly

[kimmer6160]

We have a vendor that wants a list of names, addresses, and phone numbers listed on their form. These are names that are already in our database so it seems stupid to hand write them on their form. I have created a report and it is formatted perfectly to print onto their form but now they want the names all divided evenly onto each page. So say you have 33 names and there are 19 spaces on one page of their form. They want us to put 17 names on one page and 16 on the next page rather than 19 on one and 14 on the second which is the way it prints now. This is rediculously picky but they won't budge and it is a venue that our customers want so we can't say forget it. Does anyone have any idea how I can get access to do this? I figure there has to be a way to do a record count have access divide that by 19 to figure out the number of pages needed and then have it figure out how many records to print on each page but I don't know how. Please help me!

Thanks!

 

[simongallop]

One way, though I would be surprised if it is the easiest, would be to do the following in code:

1/ Count the number of records
2/ Work out how many records per page
3/ limit the feeding query to show the first 16 (for example) records (use the top X command).
4/ Output report
5/ query for the next 16 records
etc.

HTH