yes/no

[slimjen1]

All, using ms access 2010. I have a report based on a query. I have two fields that are set up in the table as yes/no fields. When I filter this field; the drop down is yes no but upon selection it's -1 or 0. When I click to view the report; it tells me either too few parameters or the message I set up " there's no criteria for this report". All other filter fields are fine. Is there something else I have to do to be able to filter yes/no fields? Thanks

 

[slimjen1]

Do i have this in the wrong discussion? perhaps I need to post in the Form discussion? Help

 

[The_Doc_Man]

As to 1/0 for field values...

You could use a data source of =CBool(fieldname) to translate that field to TRUE/FALSE if that would be good enough.

Otherwise, instead of =CBool(), you could use =IIF( fieldname, "YES", "NO" ) to translate the data source for your report.

 

[slimjen1]

I just noticed what may be the problem. In the query; it gives me all the yes/no fields. but when I use it on the form, using the combobox for searchfields, I use the query in the recordsource from the field. For ex:

SELECT DISTINCT qryQAReport.[In QA] FROM qryQAReport;

When I run the query from the query builder within the form, It just show me the two options; yes and no. But when I run the query, it gives me all the yes no in the table for all records. I don't have this problem with the other fields on the form. I hope this makes since. What is wrong?

 

[slimjen1]

I removed the "distinct" and now it gives me the yes no but for every record. I don't know if this is correct. but when I choose a yes it still only gives me the no records. What am I doing wrong?