Query involving dates

[Guest]

I am trying to query hours worked by employees on a weekly, monthly, and
quarterly basis. I have a table called WatchHours that contains a record of
overtime hours worked by employees. Therefore, I am trying to create a query
that sums up the overtime hours for a specific employee over the week, month,
quarter , and year. If someone could help me with one of these, i should be
able to figure out the rest. I believe it has something to do with using
DateDiff in the criteria of the field.

 

[Steve Huff]

So you have a table that already has employee overtime hours in -- I assume
it has a date field, an employee name or id field, and an hours field...

You would want to run a Group By query to sum up the hours based on a date
range using "between startdate and enddate" as the criteria. The date range
would be either the week month or quater you want to sum up.

 

[Guest]

I am unaware of the code to do this.. could you please help me?

 

[Guest]

This is what i want to do: Set up a query between two tables, Employee and
WatchResults. The chairsID is the key connecting the two tables. I want
something to ask "PLease Enter a ChairsID". Then after a person enters a
valid chairsID, the First Name and Last Name are displayed with a total count
of overtime hours for a specific time period. Each record has a date
associated with it in DateWorked. So i want to count the total overtime hours
for each individual chairsID by week, month, quarter, and year. If you step
through the process of doing one of them, im sure ill be able to do the
others. Thanks in advance.