calcuating field in a query

[angie]

I have two field in a query that I would like to calculate
Field Name : “Time” and “Hours”
I would like to calculate the field Time*14 if the hoursfield is empty if no time in the time field the default would be “0”
I tried this but it still calculated if there was hours inhours field.
BY HOURS WORKED: IIf([Hours]="IS Null",Nz([Time]*14),0)

Thanks Angie

[ranman256]

You only need the NZ, not the IIF.
=nz([hrs]*14)

[Micron]

Try removing the quotes. "Is Null" would be a text value and not a test for Null.
You should not be using reserved words for field or object names (Time). For a moment, I thought Hours was reserved also, but it is Hour.
http://allenbrowne.com/AppIssueBadWord.html#H

[angie]

ok I got this to work
BY HOURS WORKED: IIf([Hours] Is Null,Nz([Time]*14))

The only thing I can not get it to do is if there is nothing in the "TIME" field is shows #error.
I need it to default to nothing iF there is nothing in the TIME field

Thanks Again Angie

[Micron]

you dropped the necessary parameter that tells the function what to use if the value is null
IIf([Hours]=IS Null, Nz([Time]*14),0)

[angie]

I need it to default to "0" if the fields [hours] and [time] is empty.
it still show the #error for the entry with the hours and time is empty everthing else works

Thanks

[JoeM]

I think Micron made a typo in he response.
I don't think there should be ab equal sign before the words IS Null.

IIf([Hours] Is Null, Nz([Time]*14),0)

[Micron]

Correct. I copied from a previous post without scrutinizing. Thanks.

[JoeM]

I copied from a previous post without scrutinizing.

Funny, I did the same think last week, and it tripped me up too!

[angie]

Thanks Everyone I have it working

Angie