Parameter Queries on a Yes/No Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a parameter query on a Y/N field. How do I control how to
answer the question? At this point i have to answer with 0 or -1.

Thanks
 
0 or False, and -1 or True sounds correct.

If you want something more than that, you could use a form with (say) a
check box. In the Criteria row of your query under the yes/no field, you
could then use something like this:
[Forms].[Form1].[Checkbox0]
Provided the form is open, the query should read the value from the form.

Ultimately, the parameter dialog in a query is not a very powerful
interface, so you will be looking at other alternatives, such as building
the Filter string for the form (or the WhereCondition for a report) on the
fly.
 
Back
Top