N
Nick
This query gives me the who has had action between a given date in a given
[Situation] but what I really need is all the employees names having data in
the "situation" or not having data. SELECT Employees.[Last Name],
Employees.[First Name], Count(EmployeeProfile.Situation) AS CountOfSituation,
Employees.[Hire Date], Employees.[Home Phone], Employees.CareerType,
Employees.Craft, Employees.Position, [Last Name] & ", " & [first Name] AS
Expr1, Employees.NotCurrentEmply, EmployeeProfile.ActionDate,
EmployeeProfile.Situation
FROM EmployeeProfile RIGHT JOIN Employees ON EmployeeProfile.SSiNumber =
Employees.SSI
GROUP BY Employees.[Last Name], Employees.[First Name], Employees.[Hire
Date], Employees.[Home Phone], Employees.CareerType, Employees.Craft,
Employees.Position, [Last Name] & ", " & [first Name],
Employees.NotCurrentEmply, EmployeeProfile.ActionDate,
EmployeeProfile.Situation
HAVING (((Employees.Craft)="CITY CARRIER" Or (Employees.Craft)="RURAL
CARRIER") AND ((Employees.Position)<>"958") AND
((Employees.NotCurrentEmply)=No) AND ((EmployeeProfile.ActionDate) Between
[ActionDate Start] And [ActionDate End]) AND
((EmployeeProfile.Situation)=[Action Request]))
ORDER BY Employees.[Last Name];
Employees.NotCurrentEmply, EmployeeProfile.ActionDate,
EmployeeProfile.Situation
HAVING (((Employees.Craft)="CITY CARRIER" Or (Employees.Craft)="RURAL
CARRIER") AND ((Employees.Position)<>"958") AND
((Employees.NotCurrentEmply)=No) AND ((EmployeeProfile.ActionDate) Between
[ActionDate Start] And [ActionDate End]) AND
((EmployeeProfile.Situation)=[Action Request]))
ORDER BY Employees.[Last Name];
[Situation] but what I really need is all the employees names having data in
the "situation" or not having data. SELECT Employees.[Last Name],
Employees.[First Name], Count(EmployeeProfile.Situation) AS CountOfSituation,
Employees.[Hire Date], Employees.[Home Phone], Employees.CareerType,
Employees.Craft, Employees.Position, [Last Name] & ", " & [first Name] AS
Expr1, Employees.NotCurrentEmply, EmployeeProfile.ActionDate,
EmployeeProfile.Situation
FROM EmployeeProfile RIGHT JOIN Employees ON EmployeeProfile.SSiNumber =
Employees.SSI
GROUP BY Employees.[Last Name], Employees.[First Name], Employees.[Hire
Date], Employees.[Home Phone], Employees.CareerType, Employees.Craft,
Employees.Position, [Last Name] & ", " & [first Name],
Employees.NotCurrentEmply, EmployeeProfile.ActionDate,
EmployeeProfile.Situation
HAVING (((Employees.Craft)="CITY CARRIER" Or (Employees.Craft)="RURAL
CARRIER") AND ((Employees.Position)<>"958") AND
((Employees.NotCurrentEmply)=No) AND ((EmployeeProfile.ActionDate) Between
[ActionDate Start] And [ActionDate End]) AND
((EmployeeProfile.Situation)=[Action Request]))
ORDER BY Employees.[Last Name];
Employees.NotCurrentEmply, EmployeeProfile.ActionDate,
EmployeeProfile.Situation
HAVING (((Employees.Craft)="CITY CARRIER" Or (Employees.Craft)="RURAL
CARRIER") AND ((Employees.Position)<>"958") AND
((Employees.NotCurrentEmply)=No) AND ((EmployeeProfile.ActionDate) Between
[ActionDate Start] And [ActionDate End]) AND
((EmployeeProfile.Situation)=[Action Request]))
ORDER BY Employees.[Last Name];