IIF Function - to include AND?

  • Thread starter Thread starter Al Mackay
  • Start date Start date
A

Al Mackay

Is it possible to do a multiple query.

e.g. I want to query a field called Issue and Date Completed to say:
if Issue = Yes, and Date Completed Is Null report out "Not Done-Team
Lead"
if Issue = No, and Date Completed is Null report out "Not Done-Admin"
if Issue = Yes or No and Date Completed is Not Null report out "ALL
DONE"

Is this possible using an IIF function, or anything?, as an expression
within a query?

Appreciate your help on this.

Many Thanks, Al ( (e-mail address removed) )
 
You can nest IIf() statements in your calculated query field:

IIf([Date Completed] Is Not Null, "ALL DONE",
IIf([Issue] = True, "Not Done-Team Lead", "Not Done-Admin"))
 
Back
Top