Calculating against Nulls in Access Query

[Alex]

Hi all,

In Microsoft Access 2000, how do I tell a query to count a null as zero? I'm
adding several columns of data, and many contain nulls, but that makes my
results be null as well. Is there any simple way to compensate for this? Maybe
at the SQL level?

I run into this often in MS SQL, but I generally use a DTS to create a temp
table and convert all null's to zero... but in this Access database, the data is
linked from a read-only table. Is there some quick/simple way to tell Access to
count null fields as zero?

Thanks,

Alex.

[Mike MacSween]

NZ()

"Alex" <al**@totallynerd.com> wrote in message
news:yd********************@sysmatrix.net...

Hi all,

In Microsoft Access 2000, how do I tell a query to count a null as zero? I'm adding several columns of data, and many contain nulls, but that makes my
results be null as well. Is there any simple way to compensate for this? Maybe at the SQL level?

I run into this often in MS SQL, but I generally use a DTS to create a temp table and convert all null's to zero... but in this Access database, the data is linked from a read-only table. Is there some quick/simple way to tell Access to count null fields as zero?

Thanks,

Alex.