Hi all,
Please could you assist?
in a query
If condition 1 is >=1
and condition 2 is >= 1
Display text
Else do nothing
I tried the below as a test but I get a expression invalid syntax
Below only shows one condition as a test
Please could you assist?
in a query
If condition 1 is >=1
and condition 2 is >= 1
Display text
Else do nothing
I tried the below as a test but I get a expression invalid syntax
Below only shows one condition as a test
Expr1: IIf([Detailed_Inspections]![CountOfLimit 1]>=1,"Test","")