MSACCESS Formula Help

[bwlytkr]

Not sure why I keep getting an Invalid Syntax error for this formula. I want it to return "Complete" in the cell when StepsDetailOpen column cell is blank. Below is the formula I'm using. Any thoughts??


Steps Detail Status: IIF([StepsDetailOpen]" ","COMPLETE")

 

[Joe4]

Try:

[COLOR=#333333]Steps Detail Status: IIF([StepsDetailOpen]="","COMPLETE","")[/COLOR]

Note that a single space (" ") is not the same as blank/empty ("").

 

[bwlytkr]

Try:

[COLOR=#333333]Steps Detail Status: IIF([StepsDetailOpen]="","COMPLETE","")[/COLOR]

Note that a single space (" ") is not the same as blank/empty ("").

That did it. Thanks

 

[Joe4]

You are welcome.