Hey, did somebody say, "EQNULL"?!?! Scott ==== Ben Petersen wrote:
> > If I use (IFNULL(Column, -0-, (Column + 2) )) I get an error or with > > (IFNULL(Column, Null, (Column + 2) )) I get a zero when the column is null > > and the calculation is fine when the column is not null. > > Is your eqnull setting off? > > Ben Petersen ==== Scott J. Salisbury Matrix Data Systems / The R:Street Journal 5114 Point Fosdick Drive NW, Suite E-272 Gig Harbor, WA 98335-1733 E-Mail Address: [EMAIL PROTECTED] Temporary URL: www.seanet.com/~sjs (downloads available) New Web Address: www.rStreetJournal.Com Direct Line: 206-423-7679 Toll Free: 888-386-5040 Seattle: 206-448-7975 Fax: 305-425-0491
