Technique to not print section(s)

[Bob Howard]

Hi,

(Access 2003) ... I break a report on a control named [PledgeNumber]. I
have a header, some detail lines (usually) and a footer.

There are cases where, as a result of a calculation that is done in the
footer, I determine that I really didn't want to print the header, any of
the details, or the footer. But again, this decision is not made until the
[PledgeNumber] footer.

So my question is ... how can I use the result if this footer calculation to
cause none of these sections to print (or even have their totals included in
the report's final total ??

Thanks in advance! I'm sure there's a simple way, but I just can't get my
arms around it...

Bob

 

[Guest]

Share the "calculation that is done in the footer".

 

[Bob Howard]

How specifically do I do that ... especially since it occurs later in time
(the footer would already have been printed).

Bob

Share the "calculation that is done in the footer".

--
Duane Hookom
Microsoft Access MVP

Hi,

(Access 2003) ... I break a report on a control named [PledgeNumber]. I
have a header, some detail lines (usually) and a footer.

There are cases where, as a result of a calculation that is done in the
footer, I determine that I really didn't want to print the header, any of
the details, or the footer. But again, this decision is not made until
the
[PledgeNumber] footer.

So my question is ... how can I use the result if this footer calculation
to
cause none of these sections to print (or even have their totals included
in
the report's final total ??

Thanks in advance! I'm sure there's a simple way, but I just can't get
my
arms around it...

Bob

 

[John Spencer]

No, what is the calculation in the footer?

Perhaps the calculation can be done elsewhere (such as in the record source
for the report) and then used to eliminate the data before it is even passed
to the report.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

How specifically do I do that ... especially since it occurs later in time
(the footer would already have been printed).

Bob

Share the "calculation that is done in the footer".

--
Duane Hookom
Microsoft Access MVP

Hi,

(Access 2003) ... I break a report on a control named [PledgeNumber]. I
have a header, some detail lines (usually) and a footer.

There are cases where, as a result of a calculation that is done in the
footer, I determine that I really didn't want to print the header, any
of
the details, or the footer. But again, this decision is not made until
the
[PledgeNumber] footer.

So my question is ... how can I use the result if this footer
calculation to
cause none of these sections to print (or even have their totals
included in
the report's final total ??

Thanks in advance! I'm sure there's a simple way, but I just can't get
my
arms around it...

Bob