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

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
 
G

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
 
U

Uninvisible

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

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])).
 

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