Access Query -- I want either "Yes," or "No," but keep getting both? -
in database, have yes/no field "active," , have built form fill out search criteria.
on form, have checkbox called chkactive (normal 2-state checkbox, defaulting true). in query, have critera of:
iif([forms]![criteria_form]![chkactive]=true,true,false)
if check chkactive, active results. if don't check chkactive, in database, regardless of whether it's active or not. if alter criteria true or false, want.
is there way tell query want false records when chkactive not checked?
ms-access ms-access-2010
No comments:
Post a Comment