IIf, with AND

[gmazza76]

Good afternoon

I am having an issue creating an "Iif" statement in my access database via a calculated cell based on data in a table I have created.
If I was doing this in excel it would be fairly easy, but I am a bit rusty with Access so I could do with pointing in the right direction.

Apologies if this is a simple question, but I am a bit lost at the moment and not sure if I am writing the formula correct with missing a parentheses.

IIf(Len(Trim([TermD]))>0) and (Len(Trim([FTE]))>0),"Leaving the Business",
IIf(Len(Trim([TermD]))>0) and (Len(Trim([FTE]))=0),"Left The Business",
[Employment]))

thanks in advance
Gavin

 

[Joe4]

Try this:

IIf((Len(Trim([TermD]))>0) and (Len(Trim([FTE]))>0),"Leaving the Business",
IIf((Len(Trim([TermD]))>0) and (Len(Trim([FTE]))=0),"Left The Business",
[Employment]))

 

[gmazza76]

Try this:

IIf((Len(Trim([TermD]))>0) and (Len(Trim([FTE]))>0),"Leaving the Business",
IIf((Len(Trim([TermD]))>0) and (Len(Trim([FTE]))=0),"Left The Business",
[Employment]))

thanks for this @Joe4,

 

[Joe4]

You are welcome.