Timesheet Totals (1 Viewer)

I have a timesheet form which the user selects a date to post time against and a subform where they record daily transactions for multiple employees. I would like to display on the form or subform a daily subtotal of ST hours for the current employee selected and a weekly subtotal of ST hours. Currently, I am only able to get it to subtotal daily ST Hours for all employees keyed to that day.

Control Source for my subtotal field txtDailyST
=DSum("[tcDailyST]","[qryDailyHours]","[tcEmployeeID]='" & [tcEmployeeID] & "'" & " And [tcDate]= '" & [tcDate] & "'")

I also tried something like.. =IIf(([tcEmployeeID]=[tcEmployeeID]) And ([tcDate]=[TcDate]),Sum([tcSTHours]),"0.00")

Help!

Hi,

Is the problem with not knowing what to use for the date criteria to cover the week? If so, could you please define for us first what the current week means? Is it starting on Sunday?

I think I would simply create a saved totals query that calculated all employees weekly hours, grouped by year and week number, then use a dlookup on that query to get the current data,

Alternatively link that query to your current forms datasource and display it joined by empID and with the current weekdate as criteria