Suppressing undesired lines

[Richard]

I am developing a report for my supervisor -- he doesn't want to see
individual detail lines under $1,000, but want them included in the
grand total.

How do I suppress lines under 1,000

 

[John Spencer]

Use some VBA code to hide/show the section as appropriate.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Amount > 1000 Then
Me.Section(acDetail).Visible = True
Else
Me.Section(acDetail).Visible = False
ENd if

End Sub


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County