Hi friends,

I have below code, i need to restrict the employee time sheet entry in daily log, which should not exceed 10 hours per day, particular emplyee / id should not enter more than 10 hours a day.

If VarType(DSum("[TIME_SPENT]", "[tbl_daily_log]", "[datec]=#" & Me.DATEc & "# and [OPE_id]=" & Me.OPE_ID & "")) > 10 Then

the above code is not working kindly help me.