How do entries repeat as many times as my expression say to?

[Guest]

I know this is a long question and I don't know if anyone can help but what I
need to do is for every $5 some one has spent they get a raffle ticket I
created a query and set up a formula to divide everybodies dollar amount by 5
now I need to take that number and duplicate their entry that many times to
be able to print out that many raffle tickets.

 

[Duane Hookom]

Create a table of numbers (tblNums) with a single numeric field (Num) and
add records 1 through [max contribution] divided by 5.
Add this table to your report's record source and set the criteria under Num
column to
<=[Contributed Dollars]\5

 

[Pat Hartman\(MVP\)]

This article from the knowledgebase - 299024 - HOW TO Skip Used Mailing
Labels and Print Duplicates in Access 2002 will show you how it is done.