NZ 1

[desperatemeasures]

I am trying to make a field on a report display a zero if it is null. In the control source of the field on the report, I have put the following: =nz([Work Units])

This is giving me #Error, what am I doing wrong?

 

[KenReay]

Hi

: =nz([Work Units])

Is the control by chance named [Work Units] ?

If yes try renaming it to (say) txtWorkUnits leaving the source as it is Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[desperatemeasures]

Hi

Thanks for the reply, but I dont follow!

The Field on the report is called Work Units.

Can you explain a bit more!

Thanks

 

[KenReay]

Hi

Then rename the Field on the report, that is what I am saying.

You cannot have the control (field) called the same as one of the patameters in the : =nz([Work Units])

Just rename the control on the report and it will work
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[jebry]

Hi!

Try it like this:

=IIf(IsNull([Work Units]) = True, 0, [Work Units])

hth
Jeff Bridgham
bridgham@purdue.edu

 

[desperatemeasures]

Thanks so much for the advice. I got it working in the query.

 

[LittleSmudge]

The ACTUAL answer is that you are using NZ wrongly.

Nz ALWAYS requires two parameters

So you need

=Nz([Work Units],0)

The first part tells Nz what to test, and what to return if the test is Not Null

The second part tells Nz what to return if the first part IS NULL.


( Use =Nz(strValueName,"&quot to return an empty string in text based work )



'ope-that-'elps.


G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D