Help with a report

S

SirPoonga

I am trying to figure out how to setup a report for a time tracking
database I setup. It does simple time tracking for employees. The
employ puts in how much time he/she worked on a project, to the nearest
15 minutes. The manager wants a report that he can specify a time
(like 40 hours) and see if an employee worked that long as reported for
the week.

I know I can display the data weekly with grouping in reports, can I
specify only show employees with less then specified hour amount for
that week?
 
D

Douglas J. Steele

You can create a query that produces total hours for each employee and put a
criteria on that query that you only want ones where total hours is less
than a value. You can then join that query to your "regular" query to get
the details for those employees of interest.
 
S

SirPoonga

But how do I do that weekly. What's nice witht he report is it can
automaticalyl group weekly and do weekly totals. How do I do weekly
with a query?
 
S

SirPoonga

But how do I do that weekly. What's nice with the report is it can
automatically group weekly and do weekly totals. How do I do weekly
with a query? I can do a query that joins the employee info table with
the times table and create a report that uses a weekly grouping with a
total field. The big question is how can I filter the data weekly to
only show those employees that have lees hours than some specified
total.
 
Top