Hello
I have a form with a check box chkExculdeEac. If this is checked I want to hide any records on the report where the EAC flag (yes/no field in table) is set to true.
I've put the following in the EAC criterior field in the reports datasource. It works fine if the check box is ticked but shows no records rather than all of them when when unchecked.
[code] iif([forms]. [frmUpdateTC]. [chkExcludeEAC], false, "") [\code]
What do I put in the true part of this statement to show all records?