return a "0" instead of a blank field

U

uuhhgg

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
 
J

John Spencer

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
'====================================================
 
D

dcsassoc

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...
 
Top