Result from a IIf statement

[Guest]

Don't know if this is possible but I was hoping some can help.

I have a IIf statement who's expersion is -([A]/>[C],[D],0) with A, B, C
and D being fields from a query, what I want to do is have a '0' returned in
the field if the result of [A]/ is 0 at the moment I get an #Error, which
is of course the correct result but this dosen't look good on a report

Many Thanks for your time and Patentice

 

[Guest]

Try this

=IIf(IsError([A]/),0,IIf([A]/>[C],[D],0))

 

[Steve Schapel]

Souchie,

If the result of [A]/ is 0, I can't see why you would get #Error.
And the only reason you would need to change the expression is if [C]
can ever be a negative value... can it?

You will probably get #Error if =0. Is this the situation you are
referring to? If so, maybe like this might be easiest...
IIf(=0 Or [A]/<=[C],0,[D])

 

[Guest]

Steve,

Many thanks and your right B can = 0 and the expression works great

Souchie,

If the result of [A]/ is 0, I can't see why you would get #Error.
And the only reason you would need to change the expression is if [C]
can ever be a negative value... can it?

You will probably get #Error if =0. Is this the situation you are
referring to? If so, maybe like this might be easiest...
IIf(=0 Or [A]/<=[C],0,[D])

--
Steve Schapel, Microsoft Access MVP

Don't know if this is possible but I was hoping some can help.

I have a IIf statement who's expersion is -([A]/>[C],[D],0) with A, B, C
and D being fields from a query, what I want to do is have a '0' returned in
the field if the result of [A]/ is 0 at the moment I get an #Error, which
is of course the correct result but this dosen't look good on a report

Many Thanks for your time and Patentice