Greetings!
I have a report that I need to limit. The problem is that I need to limit by two fields, looking for the same value:
I need all the entries where EITHER:
[Hiring Manager Name]=[mgr1]
OR
[SAP Requestor]=[mgr1]
using the SAME search term for [mgr1](let's say "jagarwal")for each field.
[Hiring Manager Name] has very few entries, and [SAP Requestor] has a lot - they are mutually exclusive, and every entry has either one or the other.
I've tried this in my query, to no avail:
IIf(([Hiring Manager Name] Is Not Null),([Hiring Manager Name]=[mgr1]),([SAP Requestor]=[mgr1]))
it just returns everything
Help, please!
Liz
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar