Section Visibility based on a Calculated Field

[Guest]

I want a section of my report (header) to be visible if the value of a
calculated field is bigger than 5. Apparently because that calculated field
is based on a module function with a different query, it seems like the
problem is much more complicated. Any idea on how this can be done? thanks
in advance.

 

[Allen Browne]

Trying to set the visibility of a section of a report will always result in
problems, i.e. the solution is worse than whatever you are trying to cure.
You will get weird problems such as "Page 8 of 6", and inconsistent results
depending on whether you print the entire result or just some of the later
pages.

To avoid those problems, do the job properly. Exclude the records from the
report's RecordSource, so they never show up in the report, and you do not
have to cover up the fact that they are still there by trying to hide them.

Whatever function call you use to determine whether the records should be
shown, use it in the WHERE clause of the query that feeds the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"questionnaire database analyst"