Suppress Records within a Report, but calculate unfiltered Sums

B

Berexa

I want to hide certain Records within a Report that have small values (so I'm
using a Filter), but I still want to show subtotals and totals, etc in the
Report which sum values for all the Records
 
M

MacDermott

That would certainly be an odd report, where the sum is not equal to the
parts, but instead of using a filter, you could use code like this in the
report's Detail_Format event: (WARNING: AIR CODE)
if MyField<MyCriteria then
Me.Visible=False
Else
Me.Visible=True
End If

Put the name of your field in for MyField, and the value of your criteria
for MyCriteria

HTH
 
Top