I would like to generate a report that auto enters a money amount based on the amount in another summary field.
I have a database of trainers, where I track their hours. At the end of each year I get them gift cards. The amount of the gift card is based on the total number of hours they trained in that year. My database creates a single record for each date they trainer trained (name, date, trained hours for that date, etc). Then at the end of the year a generate a report that uses a calculation field called "total hours" that only shows me the trainer's name and calculated total hours for the defined period. The report is sorted by "total Hours" then by "Trainer name" so the report end result is lowest hours to highest ours, sub-sorted by name. I would like to have that same report auto generate a gift card amount by my own criteria . Example: John Smith's total hours are "12", then I want a "Gift Amount" field to automatically enter "$100".
I must be missing something. Any ideas?