Hiiiiiiii All Dears:
i have three tables as in the attached Picture ,
How to Know (query )for all employees that is not in this shift.
i try :
but get "At most one record can be returned by this subquery. (Error 3354)"
i have three tables as in the attached Picture ,
How to Know (query )for all employees that is not in this shift.
i try :
Code:
SELECT tblEmploees.EmploeeID, tblShiftEmploDetils.EmploeeNo, tblShiftEmploDetils.ShiftNo, tblEmploees.EmploeeName,
(SELECT Dupe.EmploeeID
FROM tblEmploees AS Dupe LEFT JOIN tblShiftEmploDetils AS Dupe1 ON Dupe.EmploeeID = Dupe1.EmploeeNo
WHERE (((Dupe1.ShiftNo)=[Forms]![frmOrders]![subfrmShifts].[Form]![ShiftID]))) AS bff
FROM tblEmploees LEFT JOIN tblShiftEmploDetils ON tblEmploees.EmploeeID = tblShiftEmploDetils.EmploeeNo
GROUP BY tblEmploees.EmploeeID, tblShiftEmploDetils.EmploeeNo, tblShiftEmploDetils.ShiftNo, tblEmploees.EmploeeName;
but get "At most one record can be returned by this subquery. (Error 3354)"