writing a total at top of report

[ekennedy]

I have a report where I keep track of the total number of reports. The total
displays great at the bottom of the report, but if I try to display it at the
top it always displays "1". I tried to have a text box that had Control
Source set to
"=[bottomTotal]", but it still did not display that same number. Is there a
way to display a generated total at the top? Thanks

 

[Duane Hookom]

What is a "generated total"? What is "at the top"? Is this the Report Header
or the Page Header?

A simple
=Sum([your expression])
should work consistently in any header or footer other than Page sections.

 

[ekennedy]

sorry, I wasn't very clear.
Between the Report Header and Report Footer I have data grouped. In one of
the groups I have a text box,itemCounter, where the Control Source is set to
"=1" and the Running Sum is set to "Over All". In the Report Footer I have a
text box, totItems, where the Control Source is set to "=[itemCounter]". I
tried to have that in the Report Header, but it always displays "1". I then
tried to have a text box in the Report Header where the Control Source is set
to the item in the Report Footer, "=[totItems]". Once again it is still
displayed as "1" in the header, but "7" in the Footer.

What is a "generated total"? What is "at the top"? Is this the Report Header
or the Page Header?

A simple
=Sum([your expression])
should work consistently in any header or footer other than Page sections.

--
Duane Hookom
Microsoft Access MVP

I have a report where I keep track of the total number of reports. The total
displays great at the bottom of the report, but if I try to display it at the
top it always displays "1". I tried to have a text box that had Control
Source set to
"=[bottomTotal]", but it still did not display that same number. Is there a
way to display a generated total at the top? Thanks

 

[Duane Hookom]

I wouldn't use the running sum to get the total count of groups to display in
the report header. Try create a totals query that groups by your group. Then
either
- create another query based on the previous query that counts the groups
and add this to your report's record source
- use a text box in your report header with a control source of
=DCount("*","qgrpYourGroupBy")
--
Duane Hookom
Microsoft Access MVP

sorry, I wasn't very clear.
Between the Report Header and Report Footer I have data grouped. In one of
the groups I have a text box,itemCounter, where the Control Source is set to
"=1" and the Running Sum is set to "Over All". In the Report Footer I have a
text box, totItems, where the Control Source is set to "=[itemCounter]". I
tried to have that in the Report Header, but it always displays "1". I then
tried to have a text box in the Report Header where the Control Source is set
to the item in the Report Footer, "=[totItems]". Once again it is still
displayed as "1" in the header, but "7" in the Footer.

What is a "generated total"? What is "at the top"? Is this the Report Header
or the Page Header?

A simple
=Sum([your expression])
should work consistently in any header or footer other than Page sections.

--
Duane Hookom
Microsoft Access MVP

I have a report where I keep track of the total number of reports. The total
displays great at the bottom of the report, but if I try to display it at the
top it always displays "1". I tried to have a text box that had Control
Source set to
"=[bottomTotal]", but it still did not display that same number. Is there a
way to display a generated total at the top? Thanks

 

[Chris Reveille]

What i do is to put the total in the bottom of the report/group and make the
visible property to NO.
Then add a control to the top of the report/group with the control source
being the name of the hidden field at the bottom of the report/group.