ThomasFoege
asked on
Access basic If's statement?
Hello EE!
I currently have this expression:
ConsolidatedCatagory: IIf([Category]<>"";[Catego ry];[Backu pCategory] )
However, I need to add a third category. So the expression goes:
If Category not empty, use Category else
If OtherCategory not empty, use OtherCategory
Else use BackupCategory
Is that possible to do in an expression like the above?
I currently have this expression:
ConsolidatedCatagory: IIf([Category]<>"";[Catego
However, I need to add a third category. So the expression goes:
If Category not empty, use Category else
If OtherCategory not empty, use OtherCategory
Else use BackupCategory
Is that possible to do in an expression like the above?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER