I know this is wrong... but I am trying to write a DELETE Query in SQL based on certain parameters... Thanks.
DELETE tblEmployeeAccess.EmployeeID, tblEmployeeAccess.SystemID, tblEmployeeAccess.EntitlementID
FROM tblEmployeeAccess
WHERE (((tblEmployeeAccess.EmployeeID)
=(SELECT tblEmployees.EmployeeID
FROM (tblEmployees INNER JOIN (tblEmployeeAccess ON tblEmployees.EmployeeID = tblEmployeeAccess.EmployeeID) INNER JOIN tblSystems ON tblSystems.SystemID = tblEmployeeAccess.SystemID) INNER JOIN tblEntSample ON tblEmployeeAccess.EntitlementID = tblEntSample.EntitlementID)
WHERE (((tblEntSample.EntitlementName)=[Forms]![frmChoice]![lboEntitlements]) AND ((tblSystems.SystemID) = [Forms]![frmChoice]![cboChoiceSys]) AND ((tblEmployees.EmployeeID) = [Forms]![frmChoice]![cboChoiceName])))) AND
((tblEmployeeAccess.SystemID)
= (SELECT tblSystems.SystemID
FROM (tblEmployees INNER JOIN (tblEmployeeAccess INNER JOIN (tblSystems ON tblEmployeeAccess.SystemID = tblSystems.SystemID) INNER JOIN tblEntSample ON tblEmployeeAccess.EntitlementID = tblEntSample.EntitlementID
WHERE (((tblEntSample.EntitlementName)=[Forms]![frmChoice]![lboEntitlements]) AND ((tblSystems.SystemID) = [Forms]![frmChoice]![cboChoiceSys]))) AND ((tblEmployees.EmployeeID) = [Forms]![frmChoice]![cboChoiceName]))) AND ((tblEmployeeAccess.EntitlementID
= (SELECT tblEntSample.EntitlementID
FROM (tblEmployees INNER JOIN (tblEmployeeAccess INNER JOIN (tblSystems INNER JOIN (tblEntSample ON tblEmployeeAccess.EntitlementID = tblEntSample.EntitlementID) ON tblSystems.SystemID = tblEmployeeAccess.SystemID) ON tblEmployees.EmployeeID = tblEmployeeAccess.EmployeeID
WHERE (((tblEntSample.EntitlementName)=[Forms]![frmChoice]![lboEntitlements]) AND ((tblSystems.SystemID) = [Forms]![frmChoice]![cboChoiceSys]))) AND ((tblEmployees.EmployeeID) = [Forms]![frmChoice]![cboChoiceName])));
DELETE tblEmployeeAccess.EmployeeID, tblEmployeeAccess.SystemID, tblEmployeeAccess.EntitlementID
FROM tblEmployeeAccess
WHERE (((tblEmployeeAccess.EmployeeID)
=(SELECT tblEmployees.EmployeeID
FROM (tblEmployees INNER JOIN (tblEmployeeAccess ON tblEmployees.EmployeeID = tblEmployeeAccess.EmployeeID) INNER JOIN tblSystems ON tblSystems.SystemID = tblEmployeeAccess.SystemID) INNER JOIN tblEntSample ON tblEmployeeAccess.EntitlementID = tblEntSample.EntitlementID)
WHERE (((tblEntSample.EntitlementName)=[Forms]![frmChoice]![lboEntitlements]) AND ((tblSystems.SystemID) = [Forms]![frmChoice]![cboChoiceSys]) AND ((tblEmployees.EmployeeID) = [Forms]![frmChoice]![cboChoiceName])))) AND
((tblEmployeeAccess.SystemID)
= (SELECT tblSystems.SystemID
FROM (tblEmployees INNER JOIN (tblEmployeeAccess INNER JOIN (tblSystems ON tblEmployeeAccess.SystemID = tblSystems.SystemID) INNER JOIN tblEntSample ON tblEmployeeAccess.EntitlementID = tblEntSample.EntitlementID
WHERE (((tblEntSample.EntitlementName)=[Forms]![frmChoice]![lboEntitlements]) AND ((tblSystems.SystemID) = [Forms]![frmChoice]![cboChoiceSys]))) AND ((tblEmployees.EmployeeID) = [Forms]![frmChoice]![cboChoiceName]))) AND ((tblEmployeeAccess.EntitlementID
= (SELECT tblEntSample.EntitlementID
FROM (tblEmployees INNER JOIN (tblEmployeeAccess INNER JOIN (tblSystems INNER JOIN (tblEntSample ON tblEmployeeAccess.EntitlementID = tblEntSample.EntitlementID) ON tblSystems.SystemID = tblEmployeeAccess.SystemID) ON tblEmployees.EmployeeID = tblEmployeeAccess.EmployeeID
WHERE (((tblEntSample.EntitlementName)=[Forms]![frmChoice]![lboEntitlements]) AND ((tblSystems.SystemID) = [Forms]![frmChoice]![cboChoiceSys]))) AND ((tblEmployees.EmployeeID) = [Forms]![frmChoice]![cboChoiceName])));