return a "0" instead of a blank field

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
How to put a 0 in a record instead of blank. 1
Query that returns 0 instead of null 2
Multiple IIf's 6
Excel formula, sum the value cell and if empty cell left blank 0
Blank fields 3
Using "Null" in an IIf statement 2
IIF statement with blank records 1

Top