change a null value to zero

[tommyguitfiddle]

when my query runs I end up with fields that have a null value (they are
blank). my function will not work because it needs a zero quantity to add it
to another feild. Is there some sort of expression that can change that for
me?

 

[Jeff Boyce]

In a query, for a "field",
YourNewField: Nz([YourFieldName],0)
will convert a Null in [YourFieldName] to 0

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Roger Carlson]

Look up the NZ (nulltozero) function.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[tommyguitfiddle]

Thanks Jeff, that did the trick.

In a query, for a "field",
YourNewField: Nz([YourFieldName],0)
will convert a Null in [YourFieldName] to 0

Regards

Jeff Boyce
Microsoft Office/Access MVP

when my query runs I end up with fields that have a null value (they are
blank). my function will not work because it needs a zero quantity to add
it
to another feild. Is there some sort of expression that can change that
for
me?