SeanNij
asked on
IIF Function return either True or False
Hi all, trust you are well.
MS Access - building a query. I have a Y/N field.
Based on a Tick box on a form: If the tick box is true - return all the values, if the tick box is false - return only false.
I tried this: IIf([forms]![activityBar]! [CaseM]=Tr ue,OR(True ,False),Fa lse)
Clearly doesnt work.
MS Access - building a query. I have a Y/N field.
Based on a Tick box on a form: If the tick box is true - return all the values, if the tick box is false - return only false.
I tried this: IIf([forms]![activityBar]!
Clearly doesnt work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.