Query IIF statement Help

[Sweetnuff38]

I have the following code in my query and it seems to be working fine, but I would also like it to show the Not Overdue Items.


Overdue: IIf([Investigation Status]="Open",IIf([DueDate]<=Date(),"OVERDUE"))

Any help would be much appreciated!

Tracy

 

[boblarson]

Something like this?

Overdue: IIf([Investigation Status]="Open",IIf([DueDate]<=Date(),"OVERDUE", "Not Overdue"))

 

[Sweetnuff38]

Tried that, seemed to make sense to me too, but the field that should be not overdue is howing blank?

 

[boblarson]

Tried that, seemed to make sense to me too, but the field that should be not overdue is howing blank?

Okay, got the NO part in the wrong place then:

Overdue: IIf([Investigation Status]="Open",IIf([DueDate]<=Date(),"OVERDUE"), "Not Overdue")

 

[Sweetnuff38]

As usual, brilliant! Such a simple thing!

Thank very much
Tracy

 

[Dairy Farmer]

When writing IF statments I try doing the following to keep things orginised:

IIf(A=B,c,d)
A=[Amount]
B=20
c="Twenty"

d = iif(B>E,f,g)
E=20
f="More than twenty"
g="Less than twenty"

Then you start putting it together
IIf(A=B,c,(iif(A>E,f,g)))

IIf([Amount]=20,"Twenty",(iif([Amount]>20,"More than twenty","Less than twenty"
)))