Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

phpmyadmin fehler rechte unerlaubte mischung, WWWXXXApc, lilo trying to map files from unnamed device 0x0000", Wwwxxxapc, CAM::PDF::Renderer::TextF Fragen, adodb.recordset error '800a0cc1', php save mails as eml, WWWXXXAPC, sqlexpress database file auto-creation error, sqlexpress database file auto-creation error

Links

XODOX
Impressum
Datenschutz

#1: 2003 sum in report footer and no data problem

Posted on 2008-04-23 08:03:14 by jeffp

Have a textbox in a report footer that sums data using Sum. That text box
value is used in a few calculations in the footer.

Trouble is, if the report has no data then the box simply shows #error and
all following calculations fail. Nz doesn't work.

In this case it is still valid for the report to show calculated values in
the footer even though the report actually contains no data. Values used
come from other places than the report data.

Is there anyway to get that text box with the Sum statement to show 0 rather
than #error?

Jeff

Report this message

#2: Re: 2003 sum in report footer and no data problem

Posted on 2008-04-23 12:52:28 by Roger

On Apr 23, 12:03=A0am, "JeffP" <no-re...@asken.com.au> wrote:
> Have a textbox in a report footer that sums data using Sum. That text box
> value is used in a few calculations in the footer.
>
> Trouble is, if the report has no data then the box simply shows #error and=

> all following calculations fail. Nz doesn't work.
>
> In this case it is still valid for the report to show calculated values in=

> the footer even though the report actually contains no data. Values used
> come from other places than the report data.
>
> Is there anyway to get that text box with the Sum statement to show 0 rath=
er
> than #error?
>
> Jeff

the form has an 'hasData' event
create a hidden text box in your footer
and add this to the event
txtNoData =3D 1
txtSum.visible =3D false ' hides #error

and use txtNoData in your calculations
iif(txtNoData,0,txtSum) + ......

Report this message