How to "copy" group running total to report footer?

  • Thread starter Thread starter Gabe
  • Start date Start date
G

Gabe

Hello, I'm new to Access and I'm hoping someone can help me.

I wrote a report that has a group running total, and I have totals in
the report footer. I need to do a calculation in the report footer
based on fields in the report footer, plus the value in the final
group running total.

What is the easiest way to access (no pun intended) the group running
final total from the report footer?

Would greatly appreciate any help you can provide.

Thank you,

Gabe
 
I should add that I am doing an =Max() to find the highest value in
the group and then I include that value in the running total.

When I attempt to =Sum or =Max or =Last Access returns an error:
"Cannot have aggregate function in expression."

Is there a way around this?

Thank you,

Gabe
 
I should add that I am doing an =Max() to find the highest value in
the group and then I include that value in the running total.

When I attempt to =Sum or =Max or =Last Access returns an error:
"Cannot have aggregate function in expression."

Is there a way around this?

Thank you,

Gabe
Click to expand...

If I understand correctly, you are looking to make a calculation based
on values contained in text boxes (i.e., controls) that appear in the
footer of your report. It would seem then, that you can add a new
control to the footer of your report and reference the other controls
as part of your new control source. For instance, if the names of the
existing controls are SumofField1 and SumofField2, then you can create
a new text box and set the control source to = [SumofField1] +
[SumofField2]. If you are looking to do a max, of say Max1, Max2 and
Max3, you could create a new text box and set the control source to =
IIf([Max1]>[Max2],IIf([Max1]>[Max3],[Max1],[Max3]),IIf([Max2]>[Max3],
[Max2],[Max3])).
 
Back
Top