Run Iif Iif!

[Elmobram22]

Hi,

I have an Iif statement running on a query that figures out based on time if someone has slept in at work...

Sleep In: IIf([Time Out]>=#21:55:00#,"Sleep In","")

I want to add to this that I only want it to run the above Iif statement if the [Notes] column is null. I still want all records to show but only run the first Iif if the [Notes] column IsNull.

Just can't get my head around it.:banghead:

Cheers,

Paul

 

[pr2-eugin]

So something like..

Sleep In: IIF(IsNull([Notes]), IIF([Time Out]>=#21:55:00#,"Sleep In",""), "")

 

[Elmobram22]

So something like..

Sleep In: IIF(IsNull([Notes]), IIF([Time Out]>=#21:55:00#,"Sleep In",""), "")

I hate you for being so good!!

 

[pr2-eugin]

I hate you for being so good!!

Someday someone will say the same thing about you. You will get there !

Glad to help. Good Luck !