"nz,0"

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I'm using Access 2.0. The query I'm writing requires the
sum of 2 fields. If I use the "nz,0" command to make sure
the fields add up even if one of the fields has a null
value, I can't sum the new field in a later query without
getting the message:

"The Microsoft Jet database engine could not execute the
SQL statement because it contains a field that has an
invalid data type."

Is there any way to add (+) 2 fields together, even if one
has some null values, and then later sum the new field-
using 2.0?

Thanks,
Todd
 
Back
Top