Simple Formula

[deejabram]

I have created a calculated field in a table. The field calculation expression is as follows: [KA Direct Labor In]*[Pack Standard]*[KA Available Hours]+[KA OT Productive].

Basically I am reporting capabilities: However, If the field [Pack Standard] value is ZERO than I want to return a Zero in this field.

Is this a simple math problem that my mind isnt catching, or is there a way to do some kind of "return if" function making the value of this field automatically zero if any of the other fields are null?

Thanks in advance for your help!

 

[deejabram]

By the way, I am running Access 2010, if it matters.

 

[vbaInet]

You should have created your thread under the Queries section

IIF([Pack Standard] = 0, 0, [KA Direct Labor In]*[Pack Standard]*[KA Available Hours]+[KA OT [URL="http://www.access-programmers.co.uk/forums/showthread.php?t=216066#"][COLOR=darkgreen]Productive[/COLOR][/URL]])