Supressing Detail Section of Report

[Dave]

I have a report with a header section that sums a group of related records.

If the sum is zero, I need to supress the detail and display only the
header. For example:

Cat1 100
Detail1 50
Detail2 50
Cat2 0 <--- doesn't show any detail
Cat3 50
Detail1 25
Detail2 25

How can I do this in Access 2002?

 

[Marshall Barton]

I have a report with a header section that sums a group of related records.

If the sum is zero, I need to supress the detail and display only the
header. For example:

Cat1 100
Detail1 50
Detail2 50
Cat2 0 <--- doesn't show any detail
Cat3 50
Detail1 25
Detail2 25

How can I do this in Access 2002?

Just use a little code in the header section's Format event
to make the detail section invisible or visible depending on
the value of the total.

Me.Section(0).Visible = (Me.totaltextbox <> 0)