Sorry about that. I put in an extra paren. It should be:
=IIf(Nz([proc1], 0) = 0 , 0, Nz([rtn 1], 0)/[proc1])
As to your other question, it would be:
=Nz([procedures performed sub].report.[rtns 2008 - 2], 0)
This: [rtns 2008 - 2]
is an example of bad naming. It is best not to use any spaces or other
special characters other than an underscore in a name. Names really should
be letters, numbers, and underscores. Additionally, when you first see that
name, you think you are looking at math statment.
Also, in that you have something like rtns 2008 (which is probably returns
for the year 2008) suggests there may be problems with your database design.
--
Dave Hargis, Microsoft Access MVP
Kay Starnes said:
That didn't work it says I'm missing a bracket or bar...
Can you tell me where to place to Nz function on the expression
=[procedures performed sub].report.[rtns 2008 - 2]
Kay Starnes said:
I have an expression on my main report
=[Procedures Performed sub].Report.[rtns 2008 - 2]
and a divide by zero here
=([rtn 1])/([proc1])
I get ERROR# when there is no data, can you help me place the null
information in this query in the right place? And also show a zero if it's
null?