Now I very carefully avoided "EQ"Null and used "IF"Null because I knew the risks if Scott was watching!! <g>
Ben, my EQNULL setting is OFF but changing it to "ON" makes no difference but I hadn't thought to try it, so thanks. Regards, Alastair. ----- Original Message ----- From: "Scott Salisbury" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 15, 2001 6:30 PM Subject: Re: Date fields in forms & ifnull return null questions > 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 > >
