Finding amount of pay by getting time worked multiplied by hourly wage

Eggers

New member
Local time
Today, 16:42
Joined
Mar 23, 2008
Messages
6
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...
 
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.
 

Users who are viewing this thread

Back
Top Bottom