running sum of txtbox not working on first of three grouping levels

  • Thread starter Thread starter ChrisA
  • Start date Start date
C

ChrisA

I have a report which is grouped by Rep, Project and Quote. In the quote
header calculations are made in a text box to determine a total value for
the quote named txtTotalQuote

I am trying to show a running sum by Rep based on the sum of txtTotalQuote.
However whenever I run this report a message box pops up asking for a value
for txtTotalQuote. I have tried

=Sum([txtTotalQuote]) in the control source and set running sum to all three
opitons ie: no, over group and over all.

The only way I can get the sum to work is by having the sum txtbox in the
quote header but this doesn't give me the numbers I need or the correct
locatioin.

What am I missing here. Hope someone can help.
Chris
 
ChrisA said:
I have a report which is grouped by Rep, Project and Quote. In the quote
header calculations are made in a text box to determine a total value for
the quote named txtTotalQuote

I am trying to show a running sum by Rep based on the sum of txtTotalQuote.
However whenever I run this report a message box pops up asking for a value
for txtTotalQuote. I have tried

=Sum([txtTotalQuote]) in the control source and set running sum to all three
opitons ie: no, over group and over all.

The only way I can get the sum to work is by having the sum txtbox in the
quote header but this doesn't give me the numbers I need or the correct
locatioin.
Click to expand...


You can not use an aggregate function with a control.
Aggegate functions only operate on fields in the report's
record source table/query.

To calculate the total of quotes within a project, add a
text box named txtRunQuotes to the Quote Header section. Set
its control source expression to =txtTotalQuote and its
RunningSum property to Over Group. This will provide a
running sum across the quotes in a project. The total for a
procect can then be displayed in the project group footer by
using a text box named txtTotalProject with control source
expression =txtRunQuotes. You didn't say that you were
interested in this value so you can make these text boxes
invisible if you don't want to see them.

The above approach can now be applied to the Rep group by
adding another text box named txtRunProject to the project
footer. Set this text box's control source to
=txtTotalProject and RunningSum to Over Group.
 
Back
Top