Nz and Excel

[hockeyfan21]

Hi there,

I need to get the equivalent of the Nz function below so that I can connect my query to an Excel workbook. Since Excel does not allow Nz.

Expr1: Sum(Nz([Late (22 - 28 Days Late)],0)+Nz([Late Qty (> 28 Days Late)],0))

Trying something like this but can't get it working-would appreciate some help to get it working.

Expr1: Sum(IIf(IsNull([LateQty (22 - 28 Days Late)]),0))+IIf(IsNull([LateQty (> 28 Days Late)]),0)

Thank you!

Toni

 

[hockeyfan21]

I figure it out!

Sum(IIf(IsNull([LateQty (22 - 28 Days Late)]),0,[LateQty (22 - 28 Days Late)])+IIf(IsNull([LateQty (> 28 Days Late)]),0,[LateQty (> 28 Days Late)]))

Hopefully this may help someone else.

Thanks!

Toni

 

[hockeyfan21]

Hi Pat,

I've always had the issue with Nz not working in Excel but perhaps I just haven't been able to find out why. If I go to make my connection to Access, and, when it gets to the step of selecting the query that I want to bring into Excel, any query I have the "Nz" function in, never appears as an option to select. I've read in numerous places online that Excel does not like the "Nz" function, but, as I've learned so much from your posts in the past several years, I'm sure you have better insight into this & I would love to get your thoughts. Thank you so much for replying.