return a "0" instead of a blank field

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

Guest

When I run my query I have some blank feils. I would like to have those
fields to contain a zeor instead of being null. I've tried writting an IIF
statement but programming eludes me. Please help. Thank you
 
If you are using design view, try the following as a calculated field.

Field: SomeFieldZero: IIF([SomeField] is Null,0,[SomeField]



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
try nz([somefield])


John Spencer said:
If you are using design view, try the following as a calculated field.

Field: SomeFieldZero: IIF([SomeField] is Null,0,[SomeField]



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

When I run my query I have some blank feils. I would like to have those
fields to contain a zeor instead of being null. I've tried writting an IIF
statement but programming eludes me. Please help. Thank you
Click to expand...
Click to expand...
 
Back
Top