If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating overtime in report footer
I currently use the following formula in a text box in the employee footer on
my report to calculate the amount paid to each employee is paid: =([On Std Hours Sum]+[Off Std Hours Sum]+IIf([On Std Hours Sum]+[Off Std Hours Sum]40,0.5*([On Std Hours Sum]+[On Std Hours Sum]-40),0))*[Current Pay Rate] I should note that the [On Std Hours Sum] and [Off Std Hours Sum] are both sums (if you didn't already catch that!) Now, I need a sum of that formula in the report footer but as you know you can't sum a sum. I attempted to use the totals function inside the query that I have based this report on to sum the On and Off Std Hours but it only shows the last entry for each employee. Any ideas on how I can sum the above code properly? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201004/1 |
#2
|
|||
|
|||
Calculating overtime in report footer
As per my response in your previous thread, I believe you need to set a
Running Sum on a text box. -- Duane Hookom Microsoft Access MVP "Nancy via AccessMonster.com" wrote: I currently use the following formula in a text box in the employee footer on my report to calculate the amount paid to each employee is paid: =([On Std Hours Sum]+[Off Std Hours Sum]+IIf([On Std Hours Sum]+[Off Std Hours Sum]40,0.5*([On Std Hours Sum]+[On Std Hours Sum]-40),0))*[Current Pay Rate] I should note that the [On Std Hours Sum] and [Off Std Hours Sum] are both sums (if you didn't already catch that!) Now, I need a sum of that formula in the report footer but as you know you can't sum a sum. I attempted to use the totals function inside the query that I have based this report on to sum the On and Off Std Hours but it only shows the last entry for each employee. Any ideas on how I can sum the above code properly? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201004/1 . |
#3
|
|||
|
|||
Calculating overtime in report footer
Duane,
I am so sorry, I must have overlooked your suggestion in my mad dash for a solution. That did the trick and the report is working perfectly. Thank you so much! Duane Hookom wrote: As per my response in your previous thread, I believe you need to set a Running Sum on a text box. I currently use the following formula in a text box in the employee footer on my report to calculate the amount paid to each employee is paid: [quoted text clipped - 9 lines] On and Off Std Hours but it only shows the last entry for each employee. Any ideas on how I can sum the above code properly? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201004/1 |
Thread Tools | |
Display Modes | |
|
|