Sum a calculated field in Microsoft Access Reports

[nicolenj]

The following formula looks within a record and identifies if it should be rounded or not. I have this calculated field within a group footer on a report. The Formula works when all items in the group have the same value however when I get to the overall total in the Report Footer, it appears to ignore the conditional field named "round" and just picks up the first value. Since some sections of my report round and others do not, I need the report total to add the values from within each group. I tried giving the text box a Name and then used it in the Report Footer as Sum([GroupRoundedTotal]) but it prompts for a Parameter value.

How can I accomplish this?

=IIf([Round]=Yes,Round(Sum([Rate]),0),Sum([Rate]))

Please HELP!

 

[SkipVought]

Hi,

Please post MS Access questions in one of the many MS Access forums like forum703.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[nicolenj]

OOPS. Will post in the appropriate location. Thank you.