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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The query cannot be completed. 1
Visual Basic use of Null in if statements 4
Need help with if then else in VBA 2
Using IIf on a date field to return the result of an expression 5
findrecord NULL 2
Running action function from SELECT query 8
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Check box in report 2

Back
Top