Report based on query shows no data

[Whitey]

I have a report based on a query. It works fine until I add criteria to the
query in a yes/no checkbox field. When I run the query from inside the report
all the data shows up but when I run the report it's blank. The query is
based on 3 tables with one to one relationships.

Suggestions?

 

[Ken Snell [MVP]]

How do you run a query from inside a report? I am confused by your
statement.

My guess is that your criterion on the "yes/no" field is not using a correct
value for what is stored in the field. Post the SQL statement of your query
(the one with the criterion on the "yes/no" field) and let's see what you
have.