Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Prininting Quantity 1

Status
Not open for further replies.

gbianchi

IS-IT--Management
Nov 26, 2002
2
US
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
 
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
 

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
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top