Ignore blank on query expression.

[zero3ree]

I have some expressions built to calculate totals in a query. Here is the first

Engineer Total: [Engineer Hrs]*[Engineer rate].

This works when a user adds hrs to a table and the rate is a default number.

Then a total from 4 totals similar to the Engineer total are added together here:

Total Rate: [Designer Total]+[Quality Total]+[Coordinator Total]+[Engineer Total].

Works perfect if all 4 Hrs fields have data. The problem is not every entry will have hrs in each field

when this happens the Total rate does not calculate. So long story short, how do I make the Total rate bypass



the blanks or do I need to make the Engineer total force a zero on blanks?

Thank in advance for advice.

[pbaldy]

Check out the Nz() function.

[zero3ree]

Check out the Nz() function.

Thank you that looks like what I need. I assume I need to add this to each of my Hrs fields?

[pbaldy]

Yes, around each field.