#Error Message from SubReport

[Michael Charney]

I have a main report that has a subreport to it. On the sub report I
have a running total. If there are no entries in the sub-report source
table the sum total returns the #Error message for the running sum
total.

I want to watch for this on the main report and replace the #Error with
a 0 (Zero) in the control on the main report.

I can not get this to happen. I have tried both an IF statement in VBA
and the IIF in the control itself. Both work fine if there is a value in
the sub-report, but when there is not I get the #Error.

I tried to use IsNull(My Control) to watch for the error but this is not
working.

Anyone know how I do this?

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Deano]

Michael Charney wrote:

I have a main report that has a subreport to it. On the sub report I
have a running total. If there are no entries in the sub-report source
table the sum total returns the #Error message for the running sum
total.

I want to watch for this on the main report and replace the #Error
with a 0 (Zero) in the control on the main report.

I can not get this to happen. I have tried both an IF statement in VBA
and the IIF in the control itself. Both work fine if there is a value
in the sub-report, but when there is not I get the #Error.

I tried to use IsNull(My Control) to watch for the error but this is
not working.

Anyone know how I do this?

Not too sure about the referencing of the subreport but i use the following
on my report;

=IIf(IsNull(Sum([AbsenceCost])),0,Sum([AbsenceCost]))

Were you using something like this?

[Michael Charney]

Yes that is what I was doing. It does not place a 0 (Zero) in the field
if it returns the #Error.

What else can I do?

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Deano]

Michael Charney wrote:

Yes that is what I was doing. It does not place a 0 (Zero) in the
field if it returns the #Error.

What else can I do?

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I find that with a bit of experimentation you can get that first part of the
IIF correct. At the moment, whatever you have in there is incorrect. Make
sure your reference to the subreport is correct. Check out the page on the
Access Web about correct referencing.

[Michael Charney]

The page on the Access Web? Not sure I know about this. Can you give me
a link?

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Deano]

Michael Charney wrote:

The page on the Access Web? Not sure I know about this. Can you give
me a link?

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You could google it or see the FAQ but here it is;

http://www.mvps.org/access/forms/frm0022.htm

This specifc page may be what you need, or click on the Reports link.

[Nothing]

Thanks!

This is exactly what I was trying to do!!

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Deano]

Nothing wrote:

Thanks!

This is exactly what I was trying to do!!

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Bookmark that site! :)