quivalent command for nvl

E

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 :)
 
D

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#)
 
Top