By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Calculating against Nulls in Access Query

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.