Query field is blank

[kholm]

Here is my slq, and I am getting blank fields when the [hoursnotworks] is blank, but I though the IIF statement would work...
SELECT IIf([hoursnotworked]=0,[sumofclock hours],[Sumofclock hours]-[hoursnotworked]) AS [Clock hours], [BCBS Query].Initials, [BCBS Query].Firstname, [BCBS Query].Lastname
FROM [BCBS Query];
THank you for all your help!

Kristin

 

[Rich]

Look up the Nz or Is Null functions