Undefined Function 'Nz' in expression

[dragongunner0351]

Hello all I have a slight problem I am hoping someone can help me with.

I have a query that keeps giving me the following error message:

Undefined Function Nz in expression

Example: Qty Sold: Nz([Quantity Sold],0)

However when I create it this way:
IIf(IsNull([Quantity Sold]),0) I do not get an error but the fields do not calculate they show up blank instead.

Any assistance is greatly appreciated.

 

[PHV]

Double check your references:
when in VBE (Ctrl+G) menu Tools -> References ...

does the database compiles properly ?
menu Debug -> Compiles ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dragongunner0351]

Thanks for the response PHV, aside from the error code I mentioned all seems well. In regards to the References which one should I be concerned with?

Thanks again

 

[PHV]

Again, does the database compiles properly ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dragongunner0351]

Yes, the database compiles properly.

 

[PHV]

In regards to the References which one should I be concerned with
any prefixed with MISSING

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dragongunner0351]

I will check Thank you

 

[dragongunner0351]

There are no missing references, still lost

 

[PHV]

What happens if you replace this:
IIf(IsNull([Quantity Sold]),0)
with this ?
IIf(IsNull([Quantity Sold]),0,[Quantity Sold])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886