Nested IIf And in Query problem...

[andy_dyer]

Hi,

I had a Nested IIf working fine...

Fix RAG: IIf([Fix Date Variance]<=0,"G",IIf([Fix Date Variance]>5,"R","A"))

Well working kind of... as where the Actual Fix Date was blank it showed #Error...

So I tried to include an And in there as well and think I've thrown the arguemets out of the window and I've lost the head space to see what I need to do to fix this...

Fix RAG: IIf([Actual Fix Date]>0 And [Fix Date Variance]<=0,"G",IIf([Actual Fix Date]>0 And [Fix Date Variance]>5,"R","A"),"N/A")

Can anyone see what I am trying to do and help with the code?

 

[andy_dyer]

No sooner do I post then I work it out...

For anyone else with this challenge, here is my solution...

Fix RAG: IIf([Actual Fix Date]>0,IIf([Fix Date Variance]<=0,"G",IIf([Fix Date Variance]>5,"R","A")),"N/A")