Hide group footer based on field value

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

Guest

Hi,

I am using Access 2000. I have a report where my group detail section has
several fields in it, but the section itself is invisible. The fields in
the detail section are referenced by code in the "Detail1_Format" event
handler. This code uses these fields to calculate a running total. This
running total is held in a field that appears in the group footer. The
group footer includes this running total and a few other fields. I would
like the group footer not to be printed for groups where this running total
field is zero.

Can anyone tell me if there is a way to do this?

Thanks,
Paul
 
Hi,

I am using Access 2000. I have a report where my group detail section has
several fields in it, but the section itself is invisible. The fields in
the detail section are referenced by code in the "Detail1_Format" event
handler. This code uses these fields to calculate a running total. This
running total is held in a field that appears in the group footer. The
group footer includes this running total and a few other fields. I would
like the group footer not to be printed for groups where this running total
field is zero.

Can anyone tell me if there is a way to do this?

Thanks,
Paul
Click to expand...

Code the Group Footer Format event:
Cancel = [ThatControlName] = 0
 
Back
Top