D
dwaynesworld
I have a query which lists the total elasped days between the start date and
the end date and the number of vacation hours that an employee has taken.
What I would like is to exclude weekend hours from the total hours field.
Here is the query:
SELECT tblEmployeeTimeOff2.Instructor, Sum(tblEmployeeTimeOff2.[Hours
Taken]) AS [SumOfHours Taken],
DateDiff("d",([forms]![DevelopmentParamForm]![StartDate]),([forms]![DevelopmentParamForm]![EndDate])) AS TotalDays
FROM tblEmployeeTimeOff2
WHERE
(((tblEmployeeTimeOff2.Instructor)=[forms]![DevelopmentParamForm]![NameSelect])
AND ((tblEmployeeTimeOff2.Date) Between
[forms]![DevelopmentParamForm]![StartDate] And
[forms]![DevelopmentParamForm]![EndDate]))
GROUP BY tblEmployeeTimeOff2.Instructor,
DateDiff("d",([forms]![DevelopmentParamForm]![StartDate]),([forms]![DevelopmentParamForm]![EndDate]));
Any help is greatly appreciated
the end date and the number of vacation hours that an employee has taken.
What I would like is to exclude weekend hours from the total hours field.
Here is the query:
SELECT tblEmployeeTimeOff2.Instructor, Sum(tblEmployeeTimeOff2.[Hours
Taken]) AS [SumOfHours Taken],
DateDiff("d",([forms]![DevelopmentParamForm]![StartDate]),([forms]![DevelopmentParamForm]![EndDate])) AS TotalDays
FROM tblEmployeeTimeOff2
WHERE
(((tblEmployeeTimeOff2.Instructor)=[forms]![DevelopmentParamForm]![NameSelect])
AND ((tblEmployeeTimeOff2.Date) Between
[forms]![DevelopmentParamForm]![StartDate] And
[forms]![DevelopmentParamForm]![EndDate]))
GROUP BY tblEmployeeTimeOff2.Instructor,
DateDiff("d",([forms]![DevelopmentParamForm]![StartDate]),([forms]![DevelopmentParamForm]![EndDate]));
Any help is greatly appreciated