Access - form has tick for yes, want query to show tick for no

[Guest]

Hi!

In the form checkboxes are ticked if the group is involved. I however want
to show in my query a tick in the box for those not involved (i.e., having
the query show a tick as not ticked and vice versa) - any ideas?

 

[Van T. Dinh]

Use a Calculated Column in your Query:

ReversedTick: Not [YourBooleanField]