Code:
DELETE DISTINCTROW tblEmployeeReq.*, qryOperFunctReq.OperFunction
FROM tblEmployeeReq LEFT JOIN qryOperFunctReq ON (tblEmployeeReq.ReqNo = qryOperFunctReq.ReqNo) AND (tblEmployeeReq.EID = qryOperFunctReq.EID)
WHERE (((qryOperFunctReq.OperFunction) Is Null));
Ok- when I run the above query in select mode in generates the correct information.
If I remove one of the joins then it delete the records, but not the correct ones.
Solutions Tried:
1 - The Unique Record is turned to "Yes"
2 - Yes I have administrative access to the database. Also, it is not networked yet.
Any help would be greatly appreciated