 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / August 2007Payrol Totals Report
I have a payrol report that calculates the time worked and the amount earned for each record the time worked is: =[time finish]-[time start] the amount earned is: =((Hour([total hours])*60+Minute([total hours]))/60)*[rate] I would like to calculate the total amount earned for the group, thanks Isn't the total amount earned something like: =Sum( ([Time Finish]-[Time Start]) * 24 * [HourlyRate] )  SignatureDuane Hookom Microsoft Access MVP > I have a payrol report that calculates the time worked and the amount earned > for each record [quoted text clipped - 4 lines] > I would like to calculate the total amount earned for the group, > thanks Thanks Duane, but I get an error. I guess my question should be: how do you total a calculated column. The amount earned is calculated for each row and I want to total all the rows in the group footer. > Isn't the total amount earned something like: > =Sum( ([Time Finish]-[Time Start]) * 24 * [HourlyRate] ) [quoted text clipped - 7 lines] > > I would like to calculate the total amount earned for the group, > > thanks You can't total a calculated "control" across report sections. You can only total/sum values/expressions from your report's record source. SignatureDuane Hookom Microsoft Access MVP > Thanks Duane, but I get an error. > I guess my question should be: how do you total a calculated column. The [quoted text clipped - 12 lines] > > > I would like to calculate the total amount earned for the group, > > > thanks I see. I have a running total for each record now .... could I do something to just capture the last Total?. Sorry Duane I am new with access, hope I am explaining my self. > You can't total a calculated "control" across report sections. You can only > total/sum values/expressions from your report's record source. [quoted text clipped - 15 lines] > > > > I would like to calculate the total amount earned for the group, > > > > thanks I generally try to calculate totals without using running sums. For instance if a control source in the detail section is something like: Name: txtNetPrice Control Source: =[Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1) I would add a text box to a footer with a control source of: Control Source: =Sum([Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1)) You might get the same value if you set the Running Sum on Name: txtNetPrice Control Source: =[Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1) Running Sum: Over All and control source in the footer to: Control Source: =txtNetPrice SignatureDuane Hookom Microsoft Access MVP > I see. I have a running total for each record now .... could I do something > to just capture the last Total?. Sorry Duane I am new with access, hope I am [quoted text clipped - 19 lines] > > > > > I would like to calculate the total amount earned for the group, > > > > > thanks that's great Duane, that works. thank you very much Victor > I generally try to calculate totals without using running sums. For instance > if a control source in the detail section is something like: [quoted text clipped - 35 lines] > > > > > > I would like to calculate the total amount earned for the group, > > > > > > thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.