initial value

Syndicate content

I have values for four fields representing a quarterly balance in an account. They are filled in successively over time, so at any given time they may not all be filled in.
---

This is a good place to use the Nz() function. It allows you to use a value if it is not null, but if it is null use an alternate value instead. You can cascade them to successively check each field.

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit