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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

California Ed - 08 Dec 2005 18:29 GMT

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?

Reply to this Message

Duane Hookom - 08 Dec 2005 20:39 GMT

YesNo fields store either -1/yes or 0/no (or possibly Null). You can use
[YesNoField]=0
or
[YesNoField]=False
or
[YesNoField]=-1

Signature

Duane Hookom
MS Access MVP
--

>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?

Reply to this Message

Marshall Barton - 08 Dec 2005 20:40 GMT

"California Ed" <California Ed@discussions.microsoft.com>
wrote:

>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?

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

Signature

Marsh
MVP [MS Access]

Reply to this Message