By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Summing a detail field (A2003)

P: n/a
PW
How do you do it? I need to sum a field within a group after the
group changes and put it in the group footer.

Referral Header
Referral Name
Detail
Referral Dollars
Referral Footer
Total Group Referral Dollars

Thanks,

-paulw
Sep 2 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
PW wrote:
How do you do it? I need to sum a field within a group after the
group changes and put it in the group footer.

Referral Header
Referral Name
Detail
Referral Dollars
Referral Footer
Total Group Referral Dollars

Thanks,

-paulw
Review RunningSum in help.
Sep 2 '08 #2

P: n/a
PW
On Tue, 02 Sep 2008 13:07:58 -0700, Salad <oi*@vinegar.comwrote:
>PW wrote:
>How do you do it? I need to sum a field within a group after the
group changes and put it in the group footer.

Referral Header
Referral Name
Detail
Referral Dollars
Referral Footer
Total Group Referral Dollars

Thanks,

-paulw

Review RunningSum in help.

Well, the step-by-step instructions in the help are not working.

The control source of the text box (txtRezCost) in the detail section
is:
=DSum("[total]","[qryResTotalA]","[ReservationID]=reports![rptMoneybyClientReferral]![ReservationID]")

I created a text box in the Referral Footer and set it to
=Sum(Reports!rptMoneyByClientReferral!txtRezCost) and set the running
sum property to "over group"

The instructions say to just set it to the text box in the detail
section but I had to qualify it to stop getting prompted for the value
of txtRezCost when the report is run.

I am getting zero for the sum value.

-pw
Sep 3 '08 #3

P: n/a
The fact that you are being asked to provide this information, means that
the report cannot find it.

You need to check the control on the report and ensure it has the correct
ref.

"PW" <pa**********************@removehotmail.comwrote in message
news:qm********************************@4ax.com...
On Tue, 02 Sep 2008 13:07:58 -0700, Salad <oi*@vinegar.comwrote:
>>PW wrote:
>>How do you do it? I need to sum a field within a group after the
group changes and put it in the group footer.

Referral Header
Referral Name
Detail
Referral Dollars
Referral Footer
Total Group Referral Dollars

Thanks,

-paulw

Review RunningSum in help.


Well, the step-by-step instructions in the help are not working.

The control source of the text box (txtRezCost) in the detail section
is:
=DSum("[total]","[qryResTotalA]","[ReservationID]=reports![rptMoneybyClientReferral]![ReservationID]")

I created a text box in the Referral Footer and set it to
=Sum(Reports!rptMoneyByClientReferral!txtRezCost) and set the running
sum property to "over group"

The instructions say to just set it to the text box in the detail
section but I had to qualify it to stop getting prompted for the value
of txtRezCost when the report is run.

I am getting zero for the sum value.

-pw

Sep 5 '08 #4

P: n/a
PW
On Fri, 5 Sep 2008 01:22:26 +0100, " kp012g3109"
<kp********@blueyonder.co.ukwrote:
>The fact that you are being asked to provide this information, means that
the report cannot find it.

You need to check the control on the report and ensure it has the correct
ref.
Nope. I had to add Reports!rprtname
>
"PW" <pa**********************@removehotmail.comwrote in message
news:qm********************************@4ax.com.. .
>On Tue, 02 Sep 2008 13:07:58 -0700, Salad <oi*@vinegar.comwrote:
>>>PW wrote:

How do you do it? I need to sum a field within a group after the
group changes and put it in the group footer.

Referral Header
Referral Name
Detail
Referral Dollars
Referral Footer
Total Group Referral Dollars

Thanks,

-paulw

Review RunningSum in help.


Well, the step-by-step instructions in the help are not working.

The control source of the text box (txtRezCost) in the detail section
is:
=DSum("[total]","[qryResTotalA]","[ReservationID]=reports![rptMoneybyClientReferral]![ReservationID]")

I created a text box in the Referral Footer and set it to
=Sum(Reports!rptMoneyByClientReferral!txtRezCos t) and set the running
sum property to "over group"

The instructions say to just set it to the text box in the detail
section but I had to qualify it to stop getting prompted for the value
of txtRezCost when the report is run.

I am getting zero for the sum value.

-pw
Sep 8 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.