Group Details visible part of the time

  • Thread starter Thread starter Will Cunningham
  • Start date Start date
W

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?
 
Will said:
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.
Click to expand...

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

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