Hiding Lines Dynamically

The reports spits out rows of Unique G/L Accounts found within the G/L Budget Entry Table and a NL Amount field Sum which references the account. There are three distinct sections representing a range of accounts - these are departments.

Issue: If a range of accounts does not exist in the table for the department then Jet returns a blank - which is correct. The problem is that the sums are still looking for an account number and therefore display #VALUE.

Objective: Hide those rows where an account is blank.

Assumption: There must be a way to feed a HIDE value into the Auto+Hide (ColumnA) so that these offending rows do not display.

Thanks…looking forward to your response. Love the JET!

1 comment

Please sign in to leave a comment.