Doing the opposite

[Guest_imported]

I have a yes and no column. I already have the no setup in my report in which if the criteria is fulfilled there is a checkmark in the checkbox. How do i make it so that if it is a yes intead of a no, then the checkbox in the yes column will be checked; Basically telling it to do the opposite of the no checkbox.

 

[Akrogh]

Assumptions: The field in the DB for the yes column is named 'Yes'<br><br>Add 2 'blank' check boxes on your report.<br><br>In the properties for checkbox 'Yes' make 'Visible' False.<br><br>Place 1 'blank' checkbox under the 'Yes' column. In it's properties make it's 'Control Source' =[Yes]<br><br>Place the other 'blank' checkbox under the 'No' column. In it's properites make it's 'Control Source' = Not [Yes]

 

[MichaelRed]

Jim,<br><br>Just curious, but WHY would you have both a YES & NO refering to the SAME object?<br><br>If you REALLY wnat to do &quot;the Opposite&quot;, just set the &quot;No&quot; record source =Not([Yes]), b ut it makes no sense to me to have both.<br><br>Michael<br>&quot;There is never tome to do it right but there is always time to do it over&quot;<br>