I use Case

[chakatheapeman]

I think MDB uses IFF, I am not sure I use ADP.

In MS SQL.

CASE feildName WHERE Feildname IS NULL THEN feildName = 0

Off the top of my head I think that is right. I like the oracle function never found one in MS SQL.

 

[Eitan M]

Hello,

In oracle there is a sql function : nvl,
which when the value after the function is null, it puts a default value.

What is the function access' sql statement ?
Need sample code, please.

Thanks

 

[Douglas J Steele]

Nz(MyField, 0)

That will use MyField unless it's Null, in which case it'll use 0.

You can specify text or dates as the default value as well:

Nz(MyField, "Nothing")
Nz(MyField, #2005-10-06#)