Report Prininting Quantity 1

[gbianchi]

I have a report the prints like a coupon. I want to be able to print more than one coupon based on earned points . I have a quantity field in my table can i print the number of forms for that indivdual based on the quantity in the table or any other way without duplicating fields in my tables.
Thanks
Greg

 

[67peshawar294]

gbianchi,
Sound like you need to print a coupon for each x number of points accrued.
If you are running from a query, in a blank field section of the query type [earnedpoints]/(number)
('earnedpoints' is your field name and 'number'is 50,100,150,250 or however many points per coupon.)
Change "Exp" to NrCoupons or something similar then follow this thread,
thread181-388514
jim

 

[gbianchi]

That did populate multiple fields, but when i change the number it still remembers the old number. Is there a way to have a report print based on query number or field the number of times or is there some way to fix this so that it only remembers the current number and doesnt increase it every time its changed.
Thanks
Greg

 

[67peshawar294]

greg,
The "calculated field" will always be the same, dependant on the value of "[earnedpoints]/number"
I'm sitting here trying to visualize the situation...
You might want to enter the word "number" in the calculated field and it would prompt for the number to divide by. To eliminate the decimal
Int([earnedpoints]/number).
If you are working with a running total for points you need to reset the points to 0, or subtract the points from the points total for each person.
Int([earnedpoints]-[prevpoints]/number)
will prompt for the number of previous points to subtract and also for the number to divide by. It would however, subtract the same amount from the "[earnedpoints]" for each person.
If you want separate reports for each person, in the Criteria section of the "person" type;
Like [Enter Name]
Then it will prompt for the persons name, prompt for the number of points to subtract and prompt for the divisor.
jim