J
John Harrington
On my form I have a series of six unbound, unconnected check boxes
labeled (for the purposes of this post) a, b, c, d, e, and f.
When a is checked, I want my query to show all records where a is not
null. And no other records.
When both a and b are checked, I want my query to show all records
where a is not null and where b is not null. And no other records.
And so on. In other words, turning off any check box gives a query
that ignores records with non-null values of the corresponding field.
I am uncertain as to how to design this query. Could someone please
advise?
Many thanks in advance,
John
labeled (for the purposes of this post) a, b, c, d, e, and f.
When a is checked, I want my query to show all records where a is not
null. And no other records.
When both a and b are checked, I want my query to show all records
where a is not null and where b is not null. And no other records.
And so on. In other words, turning off any check box gives a query
that ignores records with non-null values of the corresponding field.
I am uncertain as to how to design this query. Could someone please
advise?
Many thanks in advance,
John