I am trying to hide rows in an access 2007 database report when the field 'PayStatus' contains certain text, but still have the amounts calculated in a running sum. The Detail Section of my Report has the following code in the 'On Format' event, however, it still shows all of the rows on the report:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Not Me.PayStatus = "Paid" Then
Cancel = True
Thanks for the help in advance.