302 Found

Found

The document has moved here.

Formula Function Reference

Our Formula Function Reference

Nz - Null Handling

Arguments: 
(Duration d)
Result Type: 
Duration
Explanation: 
This function returns d if d is not null. If it is null, it returns a 0-length duration instead. An undefined or empty field is "null." Null values don't work in calculations, which is where the Nz() function comes in handy. When Nz() finds a null, it sees it as a zero. So, if you want to perform calculations on a field that may include a null, use the Nz function.
Example: 
Nz([Actual Duration]) + Nz([Actual Duration 1]) + Nz([Actual Duration 2]) returns the totals of values in all these duration fields.
Tags:

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.