#Error & #Name?

[Guest]

Hi
I can not figure out how too get ot of a simple problem:
In a footer of a report I have a formula in a text box that work ok when
there are values to handle, but when it's emtpy strings it dont work.
The values are coming from other text boxes in the same footer.

This is simply the formula ([a]/-1) and what i tried to do and what the
result is:
Iff(IsError([a]/-1);"";([a]/-1)), result: #Name?
Iff([HasData];([a]/-1);""), result: #Name?
Iff([HasData]=0;([a]/-1);""), result: #Name?

and so on......
I am running out of "solutions".
I would be pleased if anyone know what to do.

 

[BruceM]

Check help for the Nz function. Something like:
Nz([a]/-1) could do it, or there are other parameters to Nz, as explained
in Help.

 

[John Spencer]

You might try

IIF(=0,Null,[a]/-1)

 

[Guest]

Nz helped.
If b=0 solves of course dividing zero problem.

Big thanks.
--
TomH


John Spencer skrev:

You might try

IIF(=0,Null,[a]/-1)

Hi
I can not figure out how too get ot of a simple problem:
In a footer of a report I have a formula in a text box that work ok when
there are values to handle, but when it's emtpy strings it dont work.
The values are coming from other text boxes in the same footer.

This is simply the formula ([a]/-1) and what i tried to do and what
the
result is:
Iff(IsError([a]/-1);"";([a]/-1)), result: #Name?
Iff([HasData];([a]/-1);""), result: #Name?
Iff([HasData]=0;([a]/-1);""), result: #Name?

and so on......
I am running out of "solutions".
I would be pleased if anyone know what to do.

 

[Guest]

By the way, I noticed a new problem.
I have an unbound report including a subreport. this subreport is including
another subreport, say with other words 3 levels.
In the subreport (level 2) the sums shows nothing when theres no data. The
sums are sums of data in the subreport on level 3. Thats the way it shold be.
When I see on the sums in the subreport from the main report, they show
#Error.
What do I do wrong?
The main report is only a can for the subreports.
If you need more info, be pleased to ask.

 

[BruceM]

If the main report is unbound, what sum to you hope to have on the
subreport? Without knowing a few details it is impossible to know what is
wrong. I assume Error# is showing up in a text box. From where does that
text box get its data? What formula or expression is producing Error#?
By the way, this latest question should be a new thread. I usually don't
continue to monitor a thread after the issue has been resolved, but in this
case I just forgot to strop monitoring. Your best chance for having a lot
of people see a new question is to start a new thread.

By the way, I noticed a new problem.
I have an unbound report including a subreport. this subreport is
including
another subreport, say with other words 3 levels.
In the subreport (level 2) the sums shows nothing when theres no data. The
sums are sums of data in the subreport on level 3. Thats the way it shold
be.
When I see on the sums in the subreport from the main report, they show
#Error.
What do I do wrong?
The main report is only a can for the subreports.
If you need more info, be pleased to ask.
--
TomH


TomH skrev:

Hi
I can not figure out how too get ot of a simple problem:
In a footer of a report I have a formula in a text box that work ok when
there are values to handle, but when it's emtpy strings it dont work.
The values are coming from other text boxes in the same footer.

This is simply the formula ([a]/-1) and what i tried to do and what
the
result is:
Iff(IsError([a]/-1);"";([a]/-1)), result: #Name?
Iff([HasData];([a]/-1);""), result: #Name?
Iff([HasData]=0;([a]/-1);""), result: #Name?

and so on......
I am running out of "solutions".
I would be pleased if anyone know what to do.