Replicating Microsoft Access IF statement in datameer 6.4
Hello everyone,
I am having a hard time replicating this Microsoft Access IIF statement in Datameer 6.4. I have tried to play around with the IF and ISNULLOREMPTY.
Access Syntax:
Trim(IIf([PlanningText1]<>"",ConvertHTML1([PlanningText1],""),"")) AS Details,
Trim(IIf([UserText1]<>"",ConvertHTML1([UserText1],""),"")) AS Scope,
Trim(IIf([UserText3]<>"",ConvertHTML1([UserText3],""),"")) AS Metric,
Can someone guide me in the right direction?
Thank you,
-
Hi Patrick, the syntax for Datameer is documented here: IF
That seems to be the best match for this function: https://support.office.com/en-us/article/iif-function-32436ecf-c629-48a3-9900-647539c764e3
Please sign in to leave a comment.
Comments
1 comment