Boolean parameters in query

[DKS]

Hi,

I have buily a query that uses parameters as criteria for a "YES/NO" field.
However, I do not know how to pass a true/false or yes/no parameter when I
executed the query. The system does not seem to take any value (for
everything I give there are zero records shown). If I remove this field from
the query then the query works fine.

So I am quite sure that I am not passing the boolean value correctly to the
query.

Can anyone help to explain how to do this?

Many thanks.

 

[Allen Browne]

Try -1 (for True) or 0 (for False.)

That's assuming these are Access tables (not linked from a different type of
database.)

If that still does not work, tell us more about this query.
Does it have multiple tables? What kind of JOINs?
You could switch it to SQL View, and post the SQL statement here.

 

[DKS]

Hi Allen

Yes, that works very well. Thanks for the help.