to set zero for null value in select statement

[pol]

Please anybody can let me know to give the value as zero for null values

eg:

select nvl(salary,0) from salary;

regards

Polachan

 

[Wayne-I-M]

Is Null Or 0
in the criteria row, use it like this

SELECT TableName.salary
FROM TableName
WHERE (((TableName.salary) Is Null Or (TableName.salary)=0));

 

[karl dewey]

SELECT Nz(TableName.salary, 0) AS Salary_Value
FROM TableName;

 

[Jeff Boyce]

Check Access HELP for the exact syntax.

I suspect you could use something like:

Nz([YourField],0)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Clif McIrvin]

Please anybody can let me know to give the value as zero for null
values

eg:

select nvl(salary,0) from salary;

regards

Polachan

select NZ(salary,0) from salary;