Summing in a group footer

M

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?
 
D

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"?
 
M

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.


Duane Hookom said:
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


margaret said:
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?
 
D

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


margaret said:
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.


Duane Hookom said:
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


margaret said:
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?
 
M

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

Duane Hookom said:
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


margaret said:
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.


Duane Hookom said:
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?
 
D

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


margaret said:
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

Duane Hookom said:
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


margaret said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top