return 0 when null

[Bell1991]

I need a query that will return 0 if the value is null - but also return that column name.

I have this query:

SELECT IIf(IsNull(numCost),0, numCost)
From tblTable;

But it does not come back to me as numCost - it comes back as someother column name. Also, in my query i am returning many more columns that just one

Any suggestions?

Thanks in advance

 

[Golom]

You need

SELECT IIf(IsNull(numCost),0, numCost) [COLOR=red]As [NumCost][/color]
From tblTable;

You may also try

SELECT NZ(numCost,0) [COLOR=red]As [NumCost][/color]
From tblTable;