Make table query with derived fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Andy said:
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.
Click to expand...


Sounds like you want to use the Nz function:

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