Report Format (1 Viewer)

[kitty77]

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.

Thanks

 

[arnelgp]

use filter on your report or on your report recordsource.

 

[kitty77]

What would I put in the recordsource or filter?

 

[MajP]

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.

 

[kitty77]

I'm using (below) So, I only have one record at a time. So, really nothing to group.

strWhere = "[Mrecordid]=" & Me!Mrecordid
DoCmd.OpenReport strDocName, acViewReport, , strWhere

 

[MajP]

there any way to not have the second page based on if [results] = "fail"

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.