Calculation Problem

[stanger1]

I am having a problem with calculating 3 fields to get a total for a record. The three fields that I am working with are: Quantity, Hours, and Unit Price. With Quantity or hours, either one of those two fields can be blank. I need to create a calculation that will work around blank fields to come up with a total. Any help would be greatly appreciated.

 

[scottfarcus]

Look up the Nz() function.

 

[stanger1]

Nz() function

Does anyone have any examples of how this Nz() function should be set up for my situation? Any help would be greatly appreciated.

 

[stanger1]

Calculation

Pat,

That worked great! Thanks for the help!