How do you use a yes/no field as a filter in reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can use a filter equation in another field such as: [Name] like "A*" and
the filter works fine. However I need to do the same thing on a yes/no field
but can't figure out the correct equation. Can anyone help?
 
YesNo fields store either -1/yes or 0/no (or possibly Null). You can use
[YesNoField]=0
or
[YesNoField]=False
or
[YesNoField]=-1
 
I can use a filter equation in another field such as: [Name] like "A*" and
the filter works fine. However I need to do the same thing on a yes/no field
but can't figure out the correct equation. Can anyone help?
Click to expand...


Just use either
[yesnofield] = True
or
[yesnofield] = False
 
Back
Top