Am trying to format a report such that a value does not show if the
total of the values in a field in the detail section is less than 1.
The totals appear in the group footer ; each group is a unique name.

If the total of a field in the first group is "0", the summed result
does not show (which is correct). However, each subsequent group takes
on the value of the first group, regardless of whether the value is 0
or not. I've applied the condition to the On Print (and also tried the
On Format) property and get the same results. Any suggestions to make
each group apply the condition independently vs taking on the result
of the first group, or is the only solution to output the query to a
temporary table and filter the report from the table?

TIA for any suggestions.

Ken