Summing a calculated field in a footer

C

CAM

Hello,

I have a field call Current Activity in column A and Amount Due in column B
in the detail band in my report. I made the detail band not visible. There
is footer call Claims Number I sum Current Activity - column A is fine
in the foooter, but now I want to add a calculation in column B, which the
calculation is fine, but when I want to show the correct summing in column
B in the report footer I doest't give me the sum I only get column A
(Current Activity)summed proprely. It is easy to do the =Sum() on a
particulary field and summing it properly in the report footer, but when you
do a calculation on a footer and want to sum it in the report footer it
won't happen. Any tips will be appreciated or web-site to visit. Thank you
in advance
 
S

Steve Schapel

CAM,

If I understand you correctly, the Amount Due in the Detail section is a
calculated control. So in your totals textbox in the footer, you need
to repeat the calculation, so you are referencing back to "raw" data
i.e. the fields in the record source. So, instead of...
=Sum([Amount Due])
(which is what I presume you have been trying to do, right?)
.... you need something like this...
=Sum([Original Amount]-[Payments])
(or whatever it is you do to calculate Amount Due).
 
C

CAM

Thanks for answering Steve.


No the calculated text box is in footer I just want to sum up from this
footer in the report footer.

Steve Schapel said:
CAM,

If I understand you correctly, the Amount Due in the Detail section is a
calculated control. So in your totals textbox in the footer, you need to
repeat the calculation, so you are referencing back to "raw" data i.e. the
fields in the record source. So, instead of...
=Sum([Amount Due])
(which is what I presume you have been trying to do, right?)
... you need something like this...
=Sum([Original Amount]-[Payments])
(or whatever it is you do to calculate Amount Due).

--
Steve Schapel, Microsoft Access MVP
Hello,

I have a field call Current Activity in column A and Amount Due in
column B in the detail band in my report. I made the detail band not
visible. There is footer call Claims Number I sum Current Activity -
column A is fine in the foooter, but now I want to add a calculation in
column B, which the calculation is fine, but when I want to show the
correct summing in column B in the report footer I doest't give me the
sum I only get column A (Current Activity)summed proprely. It is easy to
do the =Sum() on a particulary field and summing it properly in the
report footer, but when you do a calculation on a footer and want to sum
it in the report footer it won't happen. Any tips will be appreciated or
web-site to visit. Thank you in advance
 
D

Duane Hookom

You mention "calculation" three times in your original posting but don't
provide a clue as to the expression(s) used. Could you share this piece of
critical information?
--
Duane Hookom
MS Access MVP



CAM said:
Thanks for answering Steve.


No the calculated text box is in footer I just want to sum up from this
footer in the report footer.

Steve Schapel said:
CAM,

If I understand you correctly, the Amount Due in the Detail section is a
calculated control. So in your totals textbox in the footer, you need to
repeat the calculation, so you are referencing back to "raw" data i.e.
the fields in the record source. So, instead of...
=Sum([Amount Due])
(which is what I presume you have been trying to do, right?)
... you need something like this...
=Sum([Original Amount]-[Payments])
(or whatever it is you do to calculate Amount Due).

--
Steve Schapel, Microsoft Access MVP
Hello,

I have a field call Current Activity in column A and Amount Due in
column B in the detail band in my report. I made the detail band not
visible. There is footer call Claims Number I sum Current Activity -
column A is fine in the foooter, but now I want to add a calculation in
column B, which the calculation is fine, but when I want to show the
correct summing in column B in the report footer I doest't give me the
sum I only get column A (Current Activity)summed proprely. It is easy to
do the =Sum() on a particulary field and summing it properly in the
report footer, but when you do a calculation on a footer and want to sum
it in the report footer it won't happen. Any tips will be appreciated
or web-site to visit. Thank you in advance
 
C

CAM

HI Duane,

In the detail area in the report I have three text boxes call Claim Number,
Current Activity, and Amount Due from a query. I have a footer to sum the
Current Activity and Amount Due by Claim Number. The code for the Current
Activity is =Sum([Current Activity]), but in the Amount Due (Claim Number
footer) I made the following code/calculation =Sum(IIF([Current
Activity]=100000, 0, [Current Activity])). Now at the report footer level I
can sum the Current Activity, but I can't seem to get the total from the
summization of the Amount Due from the Claim Number footer due to my coding
I hope this helps. Thanks in advance.

Duane Hookom said:
You mention "calculation" three times in your original posting but don't
provide a clue as to the expression(s) used. Could you share this piece of
critical information?
--
Duane Hookom
MS Access MVP



CAM said:
Thanks for answering Steve.


No the calculated text box is in footer I just want to sum up from this
footer in the report footer.

Steve Schapel said:
CAM,

If I understand you correctly, the Amount Due in the Detail section is a
calculated control. So in your totals textbox in the footer, you need
to repeat the calculation, so you are referencing back to "raw" data
i.e. the fields in the record source. So, instead of...
=Sum([Amount Due])
(which is what I presume you have been trying to do, right?)
... you need something like this...
=Sum([Original Amount]-[Payments])
(or whatever it is you do to calculate Amount Due).

--
Steve Schapel, Microsoft Access MVP

CAM wrote:
Hello,

I have a field call Current Activity in column A and Amount Due in
column B in the detail band in my report. I made the detail band not
visible. There is footer call Claims Number I sum Current
Activity - column A is fine in the foooter, but now I want to add a
calculation in column B, which the calculation is fine, but when I
want to show the correct summing in column B in the report footer I
doest't give me the sum I only get column A (Current Activity)summed
proprely. It is easy to do the =Sum() on a particulary field and
summing it properly in the report footer, but when you do a calculation
on a footer and want to sum it in the report footer it won't happen.
Any tips will be appreciated or web-site to visit. Thank you in
advance
 
S

Steve Schapel

CAM,

A calculated control in the Report Foorter will need to relate to fields
in the Detail section, it will not calculate based on something that is
in a group footer section.

So, do you mean that you have a control in the Report Footer with this
control source?...
=Sum(IIF([Current Activity]=100000,0,[Current Activity]))
And it doesn't do what you expect? What exactly is the result you are
getting? And what does it show instead? Can you give a specific
example based on your actual data?

It is a bit confusing, since you said you had a Amount Due field in the
report's underlying query, and that this is represented in the report's
Detail section, and yet your footer you are doing a calculation based on
the Current Activity field? Is that right? Sorry, still not clear.
 

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