Sum of Sums in report

[Dylan Ross]

I have the following problem and would appreciate any help anyone could give:

I have a report with the following group footer calculation:

="Missing Deduct Total: " & IIf(Sum([Final Missing 401K Deduct])>12000,12000,Sum([Final Missing 401K Deduct]))

I want to get a grand total on the report footer, but each time I've tried to sum this field it tells me the syntax is incorrect. Here's what I've tried:

=Sum(IIf(Sum([Final Missing 401K Deduct])>12000,12000,Sum([Final Missing 401K Deduct])))

I know this is incorrect, but I don't know how to structure the formula.

I do not know VB, so I'm stuck with formulas in the report.

Any help would be greatly appreciated!

DR

 

[Rich]

Add an unbound hidden textbox to the detail section, set its control source to that of the original textbox, say =[Text1] or whatever the name is, name that textbox say txtBal,set the RunningSum property to overall,add another textbox to the Report footer, set its control source to =[txtBal], voila!

 

[Dylan Ross]

A little more help

First of all, thanks for the advice. I'm still a little stumped, though.

Here's how my report is set up with the fields in question:

Detail section: [Final Missing 401K Deduct]

Group Footer: =IIf(Sum([Final Missing 401K Deduct])>12000,12000,Sum([Final Missing 401K Deduct]))

Report Footer: Here's what I'm trying to accomplish: Master Sum(=IIf(Sum([Final Missing 401K Deduct])>12000,12000,Sum([Final Missing 401K Deduct]))

I realize this is the incorrect syntax, but it's what I'm trying to accomplish. I tried what you said yesterday, but when I name the text box in the group footer calculation which is the base calculation, it doesn't recognize that as a control group.

I hope this is making sense.

Thanks,

DR

 

[Rich]

place the hidden textbox in the Group footer and not the detail section