Count if Text is Equal in two Fields
in [Queries]
|
From: Tina S on 24 Mar 2010 17:20 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.
From: KARL DEWEY on 24 Mar 2010 19:05 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. "Tina S" wrote: > 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.
From: Tina S on 24 Mar 2010 21:45 I SWEAR I tried this and it did not work, but it is now. THANKS;)!!!! "KARL DEWEY" wrote: > 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. > > > "Tina S" wrote: > > > 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.
|
Pages: 1 Prev: Query multiple Criteria, pick one! Next: Returning all values with a join |