Solved IIF Statement (1 Viewer)

[Mick3911]

I am getting myself confused having spent too much time on an IIF statement

I have a query where I want to create a column named TrainingStatus and have it filled with either 'Not Trained' or 'In Progress' or 'Trained'.

I have used the following but get an error message saying that I have the wrong number of arguments.

TrainingStatus: IIf(IsNull([StartTime]),"Not Trained",IIf(Not IsNull([StartTime]) AND (IsNull([DateCompleted],"In Progress"),IIF(Not IsNull([StartTime]) AND (Not IsNull([DateCompleted]),"Trained"))

Can anyone help please?

 

[arnelgp]

TrainingStatus: Switch(IsNull([StartTime]),"Not Trained", IsNull([DateCompleted]),"In Progress", True,"Trained")

 

[theDBguy]

You could also try:

TrainingStatus: IIf(IsNull([StartTime]),"Not Trained", IIf(IsNull([DateCompleted]),"In Progress","Trained"))

 

[Mick3911]

Thank you arnelgp and theDBguy, bot work a treat, much appreciated.

 

[theDBguy]

Thank you arnelgp and theDBguy, bot work a treat, much appreciated.

Hi. You're welcome. Arnel and I were happy to assist. Good luck with your project.