Multiple Yes/No Fields in Access

[Jenni]

I am currently constructing a database to allow searchability on a
number of records, and once matched to allow these to be checked off
against one another. Each record has three states and hence I have
now icorporated three different yes/no fields.
Prior to doing this, the database was functioning with only one Yes/No
field but since including the others I can no longer return any
records from any query. Even a simple "return all records that have
one option ticked" query returns nothing.
There is obviously some conflict here that I am not aware of - does
anyone have any idea of a way round this?

Thanks in advance to any posters

Jenni

 

[Jeff Boyce]

Jenni

There's a possibility that your data could use more normalization. Having
multiple similar fields sometimes implies that there's an underlying
one-to-many relationship, better modeled by having parent and child tables.

If you need to keep the "three-yes/no" fields, then one approach would be to
add (yep, addition) the values in those fields. A "no" in Access is = 0, so
if the sum of the three fields is not 0, there must be at least one checked,
right?

Good luck

Jeff Boyce
<Access MVP>