> 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
- Date fields in forms & ifnull return null questions Alastair Burr
- Re: Date fields in forms & ifnull return null que... Ben Petersen
- Re: Date fields in forms & ifnull return null... Scott Salisbury
- Re: Date fields in forms & ifnull return ... Alastair Burr
- Re: Date fields in forms & ifnull return null que... Sami Aaron
- MS EXCHANGE ATTACH PARAMATER rich
- RE: MS EXCHANGE ATTACH PARAMATER Ben Johansen
- Re: MS EXCHANGE ATTACH PARAMATER rich
- RE: MS EXCHANGE ATTACH PARAMATER Ben Johansen
- Re: Date fields in forms & ifnull return null que... Tom Grimshaw
- Re: Date fields in forms & ifnull return null que... Bernie Corrigan
- Re: Date fields in forms & ifnull return null... Michael Young
