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

[Eggers]

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 day.

 

[SkipVought]

Hi,

"...take one time from the other..."

You are speaking in generalities. Your data is in SPECIFIC tables and fields and forms and fields.

How about some SPECIFICS?


Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[BigRed1212]

What's the table structure look like?

Maybe

tbl_hours:
personid
day
hours_worked

tbl_payrate:
personid
pay_rate

For something like that maybe

select personid, [hours_worked * pay_rate] as day_wage
from tbl_hours left join tbl_payrate on tbl_hours.personid = tbl_payrate.personid
where day = [day you want]
order by personid

HTH.