dynamic report. with columns

[scroce]

I am printing ID cards. Each ID card has 6 or 7 fields. Each client receives a set of anywhere from 5-200 cards with the same exact information on them.

The id cards get printed on a pre-printed form divided into 4 quarters. Each quarter represents 1 id card.

I have set up a table to hold the information going on the cards.

So far, I have successfully set up a report to organize the information on the table so that it fits fine into one of the quadrants on the ID card. I used columns (File>page setup).

PROBLEM - the report works if I put 4 iterations of the same record in the table - i.e. it fills up one form of 4 ID cards - but that's a pain

DESIRED RESULT - I want to have a box on the form that says "how many id cards?", and then for the report to automatically iterate the information that many times without having to have the equal amount of records.

Does this make sense? I'm stuck on what properties and methods I should look at manipulating in the form - can someone point me in the right direction?

I may not have explained this clearly enough, but any ideas you may have would be welcomed.




Seek not outside yourself; heaven is within.

 

[raskew]

Interesting problem.

Think you can find a solution here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q100146

 

[scroce]

thanks!

that certainly looks like a good start - what criteria did you enter in the search box to pull that up? Seek not outside yourself; heaven is within.