use nz() function -- Cheers Graham Kav AFL Writing Service http://www.aflwriting.com
2009/5/21 cadvantag <cadvan...@yahoo.com>: > Hello, > > I am having a problem adding two components together, when one field is > empty, my combined total of two fields remains empty or blank. > > How can I add one field to a empty field and get a numerical result. > > > > ------------------------------------ >