Conditional report printing based on field data

[hedgracer]

I have a report which prints multiple pages (about 251) based on a specific set of criteria. On each of those pages is a field named JulAPC. I would like to not print the pages which do not meet the criteria JulAPC<1.00. How would I go about doing this? I have searched google and most recommend setting this up in the query that feeds the report. JulAPC is a calculated field inside of the report so this is not possible (the report is based on a table). Thanks for all help in advance.

Dave

 

[dhookom]

Find a way to get JulAPC as a column in a query so you can use it for filtering. Base your report on the query.

Duane
Hook'D on Access
MS Access MVP

 

[genomon]

Haven't checked - will this work?

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

    If JulAPC<1.00 Then Cancel = True

End Sub

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."