Count if Text is Equal in two Fields

[Tina S]

I have a managers that do reviews on employees and i need to know if they did
a review on an employee that reports to them or to another manager.

In my table I have Mgr doing the review[Rev_Mgr] and Mgr who is
accountable[Mgr_Acct] for the person being reviewed.
In a query I am try to get it to give me a 1 if Mgr doing the review DO NOT
EQUAL Mgr who is accountable. SO the two text field need to not equal.

 

[KARL DEWEY]

Try this --
IIF([Rev_Mgr] <> [Mgr_Acct], 1, 0)

Seems like homework as there are a few others asking the same thing in
different ways.

 

[Tina S]

I SWEAR I tried this and it did not work, but it is now.
THANKS!!!!

Try this --
IIF([Rev_Mgr] <> [Mgr_Acct], 1, 0)

Seems like homework as there are a few others asking the same thing in
different ways.

--
Build a little, test a little.

I have a managers that do reviews on employees and i need to know if they did
a review on an employee that reports to them or to another manager.

In my table I have Mgr doing the review[Rev_Mgr] and Mgr who is
accountable[Mgr_Acct] for the person being reviewed.
In a query I am try to get it to give me a 1 if Mgr doing the review DO NOT
EQUAL Mgr who is accountable. SO the two text field need to not equal.