Query that sums overtime hours for employee through time period

[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.

 

[Guest]

If someone could just step me through the process in design view to group by
the chairsID in the WatchHours table and sum up the total overtime hours
worked by each chairID, i would appreicate it. This is the foreign key to my
employees table, so i would like for the names to show up if possible.

A further question involves taking the DateWorked field into consideration
so we can track from the first of the year to the current date, the first od
the quarter to the current date, the first of the month to the current date,
etc.

This is all I'm asking. It cannot be that hard! Thanks in Advance!

 

[Larry Daugherty]

If it can't be that hard, why haven't you done it? Is it that you can't be
bothered by such a trivial task but not at all bothered to ask someone else
to do it?

What have you tried? what worked and what didn't?

I recommend that you design your reports first and then design the query for
each report to fill the need. That way you'll have all of the power of the
query plus all of the sorting and grouping functions of the report writer.
If you need several reports you'll probably need several queries.

If you post back, please express concisely a single issue in each thread.
Tell us what you've got already in terms of your relevant components. Don't
allow several requests to keep creeping out throughout your post. If there
are several related elements, express them at the start.

You might visit www.mvps.org/access Look up netiquette. That is one of the
most useful Access resources on the web.

HTH