John M Sokol 19.Dec.11 03:31 PM a Web browser Approach All Releases Windows XP
It has been ages since I did anything in approach and I have forgotten more then I can remember the program. I am trying to write a program for our small volunteer fire department to keep track of stipends.
I have written a form to track and compute points earned based on events and rank for each firefighter for the week. I have created a report that gives me a total of those points and then divides then by 738.5, which is our department's weekly stipend allowance. This gives me a dollar value per point earned. What I can't figure out is how to create a form or report that will then take the dollar value of the points and multiply it by the points earned by each firefighter, so I know how much to pay them. Do I have to create a "total points" field for each firefighter? Will the total sum of a report carry to another report or form for calculation purposes?