Using "tick-box" field in parameter queries

[Lee-Anne]

Hi

I'm having difficulties using parameter queries for fields
that have a yes/no attribute.

In my table/form I have three fields for "Products" with
a "yes/no" attribute - "Credit Cards", "Loans"
& "Savings". I'm trying to set up a query which will
allow the user to select which product (or combination)
they wish to query on, i.e. they might wish to
view "Credit Cards" only or filter out "Credit Cards" and
view "Savings" & "Loans". No matter what I've tried
nothing is filtered out - all are included. It's probably
dead easy but with it being a Friday afternoon my brain's
not really functioning. Can anyone suggest a solution?

Many thanks

 

[Lowland]

Remember YES in binary is -1, NO is 0

Set your query to have the field your require (say display records with the
tick marked in the field "Loans") so that the Criteria field code is = -1
(Tick box is checked) or = 0 (Tick box is not checked)

HTH

 

[Lee-Anne]

Thanks for your reply,

I've tried this but it didn't work.

Thanks any way.