Current work week totals

[KeithB13]

Hello all,
I need to create a report that lists employees and hours they work for the week. I need to create a query that will tell a user how much time they have worked so far this week (starting monday).

I don't know how to query my date field to only display the current weeks hours. Example, if it is tuesday, I would like to be able to display the total hours for Monday and Tuesday.

Thanks,
Keith Bledsoe

 

[Rich]

Where(DatePart("ww",[MyDate])=DatePart("ww",Date()))

 

[KeithB13]

Worked like a charm. Thanks for the help.