Iff Statement Question

[LanieB]

Hello Ladies and Gents~!



This is the Iff statement I have. It's not working... I'm sure this is something SO EASY to fix but for the life of me I can't figure it out.

I am trying to get a total number of how many files we have LEFT to audit. I created an expression to the [Number of files to Audit]-[Number Audited] = [Number of Files Left]
If we haven't audited any for that paticular person that field comes back Null...
I want this field to tell me the [Number of Files to Audit] if the [Number of Files Left] is Null... that way it is saying we have 30 files left to audit out of 30... rather than 'blank' out of 30.

I hope this makes sense. Please let me know if you have any questions!

Number Left: Iff([Number of Files Left]=NULL, [Number of Files To Audit], [Number of Files Left])

[orange]

Nothing is = NULL NULL is undefined.
There is a function to see if a variable has an undefined (NULL) value.

IsNull (your field)

details at http://www.techonthenet.com/access/f...ced/isnull.php

[JoeM]

Maybe try one of these variations:

Number_Left: Iff(IsNull([Number of Files Left]), [Number of Files To Audit], [Number of Files Left])
or
Number_Left: Iff(Nz([Number of Files Left],0)=0, [Number of Files To Audit], [Number of Files Left])

[ssanfu]

How about using the NZ() function (I removed the spaces in the field names)

NumberOfFilesLeft: Nz([NumberOfFilesToAudit],0) - Nz([NumberAudited],0)

OR

Number_Left: Nz([NumberOfFilesToAudit],0) - Nz([NumberAudited],0)