G
Guest
I am wondering how i can query my data so thatit retreived a total sum of
hours worked for a specific time frame. I have a query connecting Employee
table with WatchHours table. I want to create a query that retreives their
LastName, FirstName, Title, ID from the Employee table, and OvertimeHours for
a specific time period from the WatchResults Table.
I want to be able to calculate week to day, month to date, quarter to date,
and year to date total hours worked in a report.
Is this just a matter of setting the criteria in my query for overtime
hours. By the way, DateWorked is where i retreive dates.
hours worked for a specific time frame. I have a query connecting Employee
table with WatchHours table. I want to create a query that retreives their
LastName, FirstName, Title, ID from the Employee table, and OvertimeHours for
a specific time period from the WatchResults Table.
I want to be able to calculate week to day, month to date, quarter to date,
and year to date total hours worked in a report.
Is this just a matter of setting the criteria in my query for overtime
hours. By the way, DateWorked is where i retreive dates.