simplest question...

[andrewghunt]

Hi, I have a pretty dumb question I'm sure is really easy to answer:
I'm running a report that returns the names of all companies, and their results based on a check-box, in a yes/no format, so the report looks like this:

COMPANY NAME
YES
company 1
company 3
company 6
NO
company 2
company 4

etc.

How can I filter the report so that only the "YES" results are shown?

 

[pbaldy]

If the report is based on a query, add "Yes" to the criteria row under that field.

 

[andrewghunt]

Well it originally wasn't based on a query, but now it is and works perfectly. Thanks!

 

[pbaldy]

No problem; you could also have used the wherecondition argument of OpenReport and left the source of the report alone.

 

[pieniaszek]

I have 50 different record sets of individuals and do not want the form or report to produce all the data on all 50. Do I use the "wherecondition argument of OpenReport"?

 

[pbaldy]

That or a criteria in the query are the most common methods of restricting the records displayed.