N
Nick
The query I am using is to report information by "Year" and "Quarter" but I
have found that it reports by "Quarter" regardles of year. There fore I am
getting totals of quarters for the last several years. How can it be
corrected to do as requested?
Query: SELECT Employees.SSI, Sum(OvertimeTracking.oTDLhOURUSED) AS
SumOfoTDLhOURUSED, [Last Name] & ", " & [First Name] AS Expr2, Employees.Day,
Employees.otdeirelist, OvertimeTracking.Quarter, Sum(OvertimeTracking.oTDLOP)
AS SumOfoTDLOP, Sum(OvertimeTracking.oTBlocked) AS SumOfoTBlocked,
Sum(OvertimeTracking.oVERtIMErEFUSED) AS SumOfoVERtIMErEFUSED,
Format([ActionDate]) AS Expr1
FROM Employees INNER JOIN OvertimeTracking ON Employees.SSI =
OvertimeTracking.EMPiD
WHERE (((OvertimeTracking.aUTHORIZED) Like 1 Or
(OvertimeTracking.aUTHORIZED) Like 4))
GROUP BY Employees.SSI, [Last Name] & ", " & [First Name], Employees.Day,
Employees.otdeirelist, OvertimeTracking.Quarter, Format([ActionDate])
HAVING (((Employees.otdeirelist) Like "10" Or (Employees.otdeirelist) Like
"12") AND ((OvertimeTracking.Quarter)=[Enter Quarter]));
have found that it reports by "Quarter" regardles of year. There fore I am
getting totals of quarters for the last several years. How can it be
corrected to do as requested?
Query: SELECT Employees.SSI, Sum(OvertimeTracking.oTDLhOURUSED) AS
SumOfoTDLhOURUSED, [Last Name] & ", " & [First Name] AS Expr2, Employees.Day,
Employees.otdeirelist, OvertimeTracking.Quarter, Sum(OvertimeTracking.oTDLOP)
AS SumOfoTDLOP, Sum(OvertimeTracking.oTBlocked) AS SumOfoTBlocked,
Sum(OvertimeTracking.oVERtIMErEFUSED) AS SumOfoVERtIMErEFUSED,
Format([ActionDate]) AS Expr1
FROM Employees INNER JOIN OvertimeTracking ON Employees.SSI =
OvertimeTracking.EMPiD
WHERE (((OvertimeTracking.aUTHORIZED) Like 1 Or
(OvertimeTracking.aUTHORIZED) Like 4))
GROUP BY Employees.SSI, [Last Name] & ", " & [First Name], Employees.Day,
Employees.otdeirelist, OvertimeTracking.Quarter, Format([ActionDate])
HAVING (((Employees.otdeirelist) Like "10" Or (Employees.otdeirelist) Like
"12") AND ((OvertimeTracking.Quarter)=[Enter Quarter]));