#Error in Report Control - Access 2002

[tallbarb]

When displaying a report where a bound control is doing a "sum", I see #Error - because there's nothing to add up. I've tried this:

=IIf(IsError(Sum([FMLA Hours])),0,Sum([FMLA Hours]))

The field being summed is FMLA Hours. I would like to display a zero instead of "#Error". I found this in the forums in response to one of my previous posts - I had used it in a different version of Access and it worked. Now it doesn't. What am I doing wrong? For the life of me, I just don't see the problem. Thanks for your help!

 

[Drainie]

Tallbarb

Have you tried the following instead of what you have:

=Sum(Nz([FMLA Hours]))

 

[tallbarb]

Darn. That didn't work, either.
I entered
=Sum(Nz([FMLA Hours]))
in the control source of the report control. Annoying....

 

[CosmoKramer]

Is the [tt]=Sum(Nz([FMLA Hours]))[/tt] textbox in the page footer?? It should be in the report footer.....

Hoc nomen meum verum non est.

 

[tallbarb]

It's in the detail band, 2 group footers AND the report footer.

 

[tallbarb]

Oooppps - not in the detail band - just 2 group footers and report footer.