Nested IIF Statement

[Antony Cole]

hi,

i'm trying to do a nested iif statement on a query. I have 2 dates target start and completion date, I also have a Status column. by default the status should be "Due" unless completion date is blank but has passed the target date then it should be "Overdue". If a date has been entered into completion date I want status to say "Complete". Please help

 

[Beetle]

If you're doing this in a query field;

Status:IIf([CompletionDate] Is Not Null, "Complete", IIf([CompletionDate] Is Null And [TargetDate]<Date(), "Overdue", "Due"))

 

[Antony Cole]

Thanks for your help, much appreciated!