Summing in a group footer

[margaret]

I have a an amount I'm attempting to sum. The control is amount from
tblsales. I have the detail and then in the group footer I would
=sum([amount]) I can't get it to work in either the group footer or the page
footer. However it does work in the report footer. WHY?

 

[Duane Hookom]

Aggregates will not work in Page Header and Footer sections. They should work
well in Report and Group Header and Footer sections.

What do you mean by "can't get it to work"?

 

[margaret]

Yea ... "can't get it to work" is a lousy way of saying ... I put the control
in the detail section that says =[amount] and one in the group footer that
says =Sum([amount]). However, the control in the group footer gives me the
same amount as in detail.

Aggregates will not work in Page Header and Footer sections. They should work
well in Report and Group Header and Footer sections.

What do you mean by "can't get it to work"?

--
Duane Hookom
Microsoft Access MVP

I have a an amount I'm attempting to sum. The control is amount from
tblsales. I have the detail and then in the group footer I would
=sum([amount]) I can't get it to work in either the group footer or the page
footer. However it does work in the report footer. WHY?

 

[Duane Hookom]

Is [Amount] a field in your report's record source? Using
=Sum([Amount])
in a group header or footer will always sum all of the details within the
group. If there is only one record in the group, the values will be the same.

--
Duane Hookom
Microsoft Access MVP

Yea ... "can't get it to work" is a lousy way of saying ... I put the control
in the detail section that says =[amount] and one in the group footer that
says =Sum([amount]). However, the control in the group footer gives me the
same amount as in detail.

Aggregates will not work in Page Header and Footer sections. They should work
well in Report and Group Header and Footer sections.

What do you mean by "can't get it to work"?

--
Duane Hookom
Microsoft Access MVP

I have a an amount I'm attempting to sum. The control is amount from
tblsales. I have the detail and then in the group footer I would
=sum([amount]) I can't get it to work in either the group footer or the page
footer. However it does work in the report footer. WHY?

 

[margaret]

yes the field is tblsales.amount ... I have more than one line item in the
detail section. For instance I have a game 101 that has sales of $1,000 and
$2,000 so in the group footer section for game I should have $3,000

Is [Amount] a field in your report's record source? Using
=Sum([Amount])
in a group header or footer will always sum all of the details within the
group. If there is only one record in the group, the values will be the same.

--
Duane Hookom
Microsoft Access MVP

Yea ... "can't get it to work" is a lousy way of saying ... I put the control
in the detail section that says =[amount] and one in the group footer that
says =Sum([amount]). However, the control in the group footer gives me the
same amount as in detail.

Aggregates will not work in Page Header and Footer sections. They should work
well in Report and Group Header and Footer sections.

What do you mean by "can't get it to work"?

--
Duane Hookom
Microsoft Access MVP


:

I have a an amount I'm attempting to sum. The control is amount from
tblsales. I have the detail and then in the group footer I would
=sum([amount]) I can't get it to work in either the group footer or the page
footer. However it does work in the report footer. WHY?

 

[Duane Hookom]

If you aren't getting a total then you have something wrong in some property
of the text box. I would try adding a new text box with a control source of:
=Sum([Your Field Name Here])
--
Duane Hookom
Microsoft Access MVP

yes the field is tblsales.amount ... I have more than one line item in the
detail section. For instance I have a game 101 that has sales of $1,000 and
$2,000 so in the group footer section for game I should have $3,000

Is [Amount] a field in your report's record source? Using
=Sum([Amount])
in a group header or footer will always sum all of the details within the
group. If there is only one record in the group, the values will be the same.

--
Duane Hookom
Microsoft Access MVP

Yea ... "can't get it to work" is a lousy way of saying ... I put the control
in the detail section that says =[amount] and one in the group footer that
says =Sum([amount]). However, the control in the group footer gives me the
same amount as in detail.


:

Aggregates will not work in Page Header and Footer sections. They should work
well in Report and Group Header and Footer sections.

What do you mean by "can't get it to work"?

--
Duane Hookom
Microsoft Access MVP


:

I have a an amount I'm attempting to sum. The control is amount from
tblsales. I have the detail and then in the group footer I would
=sum([amount]) I can't get it to work in either the group footer or the page
footer. However it does work in the report footer. WHY?