Eggers
03-26-2008, 10:18 AM
I need to make a wage slip but I can't figure out how to make the report take one time from the other, then multiply it by the wage to find out the pay for that amount of time...
|
View Full Version : Finding amount of pay by getting time worked multiplied by hourly wage Eggers 03-26-2008, 10:18 AM I need to make a wage slip but I can't figure out how to make the report take one time from the other, then multiply it by the wage to find out the pay for that amount of time... ASherbuck 03-26-2008, 10:50 AM I'm going to try to show how I would do this. TblTimeClock PunchRecord TimeIn TimeOut autonumber date/time date/time on the report I would have an ubound text box whose source would be the DSum of (TimeIn - TimeOut)*Wage, I don't remember the specifics of DSums arguments I dont use it much. So just hit F1 and lookup DSum Of Course I don't know if you have a table set up for wages, or if it's case by case. If I had a bunch of people making minimum I may make a table for wages. I'm a bit sketchy but I'm not sure what you've got. |