Query Issue - Null Value - Return Generic Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to query using the following expression:

TO BE APPROVED BY: IIf([TO_BE_APPROVED_BY] Is Not Null,[TO_BE_APPROVED_BY])
Or IIf(([TO_BE_APPROVED_BY] Is Null) And ([REQUEST_STATUS]="Awaiting
Approval"),"Cash Team Lead")

Basically what I want to do is for the column called "TO BE APPROVED BY", it
should return any values in [TO_BE_APPROVED_BY] if it has a value and is
[REQUEST_STATUS]="Awaiting Approval". If their is no value and is null, then
return "Cash Team Lead".

What am I doing wrong?
 
IIF(NOT ISNULL([TO_BE_APPROVED]) AND ([REQUEST_STATUS] = "Awaiting
Approval"),[TO_BE_APPROVED_BY],"Cash Team Lead")

HTH,
Barry
 
Back
Top