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.