Hi, is it possible to sum 3 expression columns in query and how to do it?
The expression columns is:
curruntInspection: Sum(IIf([Type] Like "curruntInspection*";1;Null))
targetedInspection: Sum(IIf([Type] Like"targetedInspection*";1;Null))
thematicInspection: Sum(IIf([Type] Like "thematicInspection*";1;Null))
how can I sum them?
Thanks.
The expression columns is:
curruntInspection: Sum(IIf([Type] Like "curruntInspection*";1;Null))
targetedInspection: Sum(IIf([Type] Like"targetedInspection*";1;Null))
thematicInspection: Sum(IIf([Type] Like "thematicInspection*";1;Null))
how can I sum them?
Thanks.