Coalesce(), Nz() alternative in Access SQL 2010

Question

I am trying to fetch null values but coalesce() and Nz() are not working.

select Nz(delay_head,0) from sumb where dep_reg = 'er'

exception · Answer

Try

SELECT IIf(IsNull(delay_head),0,delay_head) AS [delay_head_result]
FROM sumb
WHERE dep_reg='er';