No as null? (1 Viewer)

[ankrumc]

I have a checklist that I have for preferences i.e.

Golf

Tennis

Club Member

These are all check boxes that shoot into my query criteria like this

[Forms]![RelationshipSort]![Golf]

Its controlling just fine, but I want the "no"s to not show up, so if I want golfers only, the ones who don't play tennis won't show up. Maybe some way to make no=null?

Thanks!

 

[drusteeby]

Try doing this


[Forms]![RelationshipSort]![Golf] OR [Forms]![RelationshipSort]![Golf] Is Null

For all of your criteria.

 

[ankrumc]

Its still accomplishing the same task. I need something to exclude anything that is a no. I feel like I've done it before, but I can't think of why it's not going the way I want it.

I keep working on different things, I'd love any other suggestions.