Summing a detail field (A2003)

[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

[Salad]

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.

[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

[kp012g3109]

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

[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