show records when two fields not equal

  • Thread starter Thread starter Tina S
  • Start date Start date
T

Tina S

I am trying to build a report about reviews done on employees. We have
Managers assgined to Employees that do reviews. Sometimes we have manager
who are NOT assigned to an employee do a review. I want to be able to find
these records.

So I need the records for when a non-assigned manager reviews a non-assigned
employee.

Employee 1 assigned to Mgr 1
Employee 1 reviewed by non assigned Mgr 2
 
"how" depends on "what" ... and we don't know what data you're working with.

More info, please...

(for example, what tables do you find the data in?)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
I am assuming that all review records are in a single table --
SELECT FName, LName, EmployeeID, tblEmployeeReview.Reviewer, [XX].Reviewer
FROM (tblEmployee LEFT JOIN tblEmployeeReview ON
tblEmployee.EmployeeID = tblEmployeeReview.EmployeeID) LEFT JOIN
tblEmployeeReview AS [XX] ON tblEmployee.EmployeeID = [XX].EmployeeID
WHERE tblEmployeeReview.Reviewer <> [XX].Reviewer;
 
This is a bit complicated for me. Let me give you some more information and
maybe you can use it to help me understand.

I have tblReview with EMP and MGR fields. This is the review table.

I have tblHierachy with EMP and MGR. This is the Hierarchy table showing
the Manager and the Employees assigned to them.

When you give me the information, do I open a new query, go in the SQL view
and put in in there?

Thanks for your help and patience.


KARL DEWEY said:
I am assuming that all review records are in a single table --
SELECT FName, LName, EmployeeID, tblEmployeeReview.Reviewer, [XX].Reviewer
FROM (tblEmployee LEFT JOIN tblEmployeeReview ON
tblEmployee.EmployeeID = tblEmployeeReview.EmployeeID) LEFT JOIN
tblEmployeeReview AS [XX] ON tblEmployee.EmployeeID = [XX].EmployeeID
WHERE tblEmployeeReview.Reviewer <> [XX].Reviewer;

--
Build a little, test a little.


Tina S said:
I am trying to build a report about reviews done on employees. We have
Managers assgined to Employees that do reviews. Sometimes we have manager
who are NOT assigned to an employee do a review. I want to be able to find
these records.

So I need the records for when a non-assigned manager reviews a non-assigned
employee.

Employee 1 assigned to Mgr 1
Employee 1 reviewed by non assigned Mgr 2
Click to expand...
Click to expand...
 
Back
Top