I have a report that normally has two pages to it. Is there any way to not have the second page based on if [results] = "fail"
Rather than having to creating a separate report.
A Report lets you do a Group By. Make your Group By top level on the Pass / Fail Comment and Sort Descending. In the properties set it to break after the group. May require a Pass/Fail group footer to break after the Passes.
You have to give more detail. Reading that, we would assume the first page is RESULTS that passed and the second page are RESULTS that failed. Maybe a screen shot of what you have would help.