S
stevefell
Guest
I would like a sum iif statement which returns '1' if two conditions are true.
i.e.
=SUM IIF([period])=1,1,0) + IIF([leavID])=3,1,0))
if period =1 and leavID=3 then the text box value =1
Is this possible either using a text box on a report or calculated field in a query?
Thanks
Steve
i.e.
=SUM IIF([period])=1,1,0) + IIF([leavID])=3,1,0))
if period =1 and leavID=3 then the text box value =1
Is this possible either using a text box on a report or calculated field in a query?
Thanks
Steve