Make table query with derived fields

[Guest]

I am trying to create a make table query that contains an end value dervied
from numberic fields within the table. I have 9 different columns where I
need to add the values and in the made table, add an additional field which
details the total for each row.

So: Expr1: [Field1]+[Field2]+...+[Field9]. However where the fields are
empty, the function is not operating and just returning Expr1 as blank. Short
of running an update to query to update all blank cells in Field1-9, there
must be an easier way!!!
Help.

 

[Marshall Barton]

I am trying to create a make table query that contains an end value dervied
from numberic fields within the table. I have 9 different columns where I
need to add the values and in the made table, add an additional field which
details the total for each row.

So: Expr1: [Field1]+[Field2]+...+[Field9]. However where the fields are
empty, the function is not operating and just returning Expr1 as blank.

Sounds like you want to use the Nz function:

Expr1: Nz([Field1],0)+Nz([Field2],0)+...+Nz([Field9],0)