Suppress Records within a Report, but calculate unfiltered Sums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Navigate to Open a form and Unfilter if prev. Filtered 1
Calculating a grand total for an unbound control in a report 9
Subtotal in a report 1
Want Sum in Report Header of calculated field in Report Detail ? 1
how to sum per page & per all report 1
Access Access Report Works on One Machine but not Another 3
Summing the value of calculated control on subform to a main form 2
Rpt totals of datediff field only if checkbox of another field che 1

Back
Top