kokoen
02-26-2001, 04:14 AM
Hi,
I've got a form with only checkboxes, activating a query of a bunch of Y/N fields. How can I make sure Access ignores the checkboxes that weren't checked in the form? Now if I check box A, I only get the records where field A = Y and field B = 0, while I should see all records where field A = Y, regardless the value of the other fields.
How can I solve this?
I've got a form with only checkboxes, activating a query of a bunch of Y/N fields. How can I make sure Access ignores the checkboxes that weren't checked in the form? Now if I check box A, I only get the records where field A = Y and field B = 0, while I should see all records where field A = Y, regardless the value of the other fields.
How can I solve this?