IIf funtion based on multiple criteria

[Jennifer]

I have the following expression but want the criteria to include 2 fields:

IIf(IsNull(

---

),2,1)

If HR is null AND NARC is null I want a 2 otherwise a 1.

Thank you for your help.

 

[Duane Hookom]

Try
IIf(IsNull(

---

) AND IsNull([NARC]),2,1)

 

[Marshall Barton]

I have the following expression but want the criteria to include 2 fields:

IIf(IsNull(

---

),2,1)

If HR is null AND NARC is null I want a 2 otherwise a 1.

---

IIf(IsNull(

---

) And IsNull(NARC),2,1)

will do what you asked, but without any context I have no
way of knowing if that's the best way to do it or even if
that is what you need to do.