Group Details visible part of the time

[Will Cunningham]

On a report in Access 2000 I grouped records by account
numbers and placed each group's sum in a footer. I want to
print the sum all of the time and the detail records some
of the time depending on the value in the account field.

For example, if the account field is => 3000 and < 4000 do
not print each line only the total.

What's the best way to do this?

 

[Marshall Barton]

On a report in Access 2000 I grouped records by account
numbers and placed each group's sum in a footer. I want to
print the sum all of the time and the detail records some
of the time depending on the value in the account field.

For example, if the account field is => 3000 and < 4000 do
not print each line only the total.

You can use code in the detail section's Format event:

Me.Section(0).Visible = (Me.txtAccount < 3000 _
And Me.txtAccount >= 4000)