Hello guys,

I am creating a report to calculate the total hours of an employee i did that just fine and it works perfect

But what i needed to do is  (for Overtime purposes)

Get the hours by week worked  and calculate those hours for that week  

the pay is based on a two weeks work but i want to know which week an employee worked Overtime

when i did that the data came as a duplicate therefore the total hours was doubled i created four parameter

Week1start

week1end

week2start

week2end

i have two tables

Employee table with column employeeid

timecard table , with cloumns: clockin, clockout ,employeeid

any help is very appreciated