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

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

Post by VGFueWF » Sat, 30 Apr 2005 18:08:04


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?
 
 
 

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

Post by Van T. Din » Sat, 30 Apr 2005 18:33:48

Use a Calculated Column in your Query:

ReversedTick: Not [YourBooleanField]

--
HTH
Van T. Dinh
MVP (Access)





want