Duplicating records (please convert my psuedocode to VBA)

[efreet29]

I need to print a report on a watermarked paper. The watermarked paper has space for 3 short slips, and each slip has can hold 5 records. The 3 slips should be printing the same set of records and look the same. If I get more than 5 records to print, extra records should be printed on the next watermarked paper.

The problem is I don't know how to use VBA I prepared psuedocode for my problem above. Can anyone convert this to VBA?

-Input: Records


Sub DuplicateRecords()

NumRecords = num(Records)
Do While NumRecords - 5 > 0
'Append First 5 Records to TempTable 3 times
'Delete First 5 Records
NumRecords = NumRecords - 5
Loop

End Sub 

Please help! If anyone has better code design, I'm all ears for that too.

[msoffice.vidyarthi]

1 ) It would be good if you explain it more clearly, what is the kind of input and what is the kind of output ur luking 4

2 ) can you get some sample data which help us to come up with solution

[June7]

This is essentially duplicate/continuation of https://www.accessforums.net/reports...age-30018.html