access report / display value based on condition

[Guest_imported]

Hi everyone, this sounds easy enough but I can't figure it out. We have a "total" column on a report. It sums a running total. We would like for the data to be printed only if it exceeds a certain dollar amount, BUT have the total be calculated even if it doesn't.

For edxample, the table would look like:

Item total_cost
A $20.00
B $10.00
C $50.00

We would want to display a total cost only if it exceeds
$10.00, but compute a total regardless of value. So we would want the report to look like:

Item total_cost
A $20.00
C $50.00

grand total (all items): $80.00

How to do? Thanks in advance. drStealth

 

[CosmoKramer]

I don't think its good practice to total on invisible fields, but this should work:

In the On Format property of your reports detail section, put something like this:

If Me.total_cost <= 10 Then
Cancel = True
End If

With your grand total field in the report footer it will still display the total of all fields...

HTH