Null function

[PatelRam]

Hi,

what is Null function in Ms-access ?

Oracle : select nvl(comm,0) from employee;
Ms-Access : ??

Thanks,

Ram

 

[lupins46]

I assume you are referring to NZ().

NZ(myfield,0) will return 0 if myfield is null.

General form is Nz(myfield,value) but default vlues are 0 for numbers and "" for strings.

 

[PatelRam]

I tried but it is giving undefined function error

Basically I am using following query in crystal Designer.
I am using access database in backend.

My sql query is

select NZ(division,"Unassigned") from table_name

but it is giving me error.

Am I doing some thing wrong here ???

 

[nabiS2K]

Nz is for use in access itself. It is possible that the DB engine for crystal will work with ISNULL([FieldValue], [ValueIfNull]) instead