Stored Query - Criteria if box = true, => true, if box = false =>

  • Thread starter Thread starter BlueWolverine
  • Start date Start date
B

BlueWolverine

Hello,
MS Access 2003 on XP Pro.

I have a search panel i built and I want to all the user to either specify
"Search by other" or Don't. The data gets pulled out of a stored query.

What I mean is that my data has a True/False field called "Other" I want a
control the user can toggle between true and false to indicate "YES, limit
search to only those where Other = True" or "No, return all results
regardless of Other." I wouldn't necessarily mind being able to search for
the third state, "Yes limit my search to only those where Other = False" but
I don't necessarily need it.

Ideas?
 
A check box would work. Assuming the check box is named chkOther and it
being checked means limit to only those rows where Other is true, you would
then add criteria in your query for the field Other:

Like IIF(Forms!MyForm!chkOther = True, True, *)
 
Back
Top